FUSION.PAY_CORE_UTILS

Summary

FUSION.PAY_CORE_UTILS

Content

Hi,

 

Can someone share the package body of the FUSION.PAY_CORE_UTILS.

 

Iam facing an issue while retriving Balance values for all the employees using the pay_balance_view_pkg.get_balance_dimensions package. The error says"

The payroll relationship action ID is invalid. Details: Contact your help desk.
ORA-06512: at "FUSION.PAY_CORE_UTILS", line 1986
ORA-06512: at "FUSION.APP_EXCEPTION", line 60

 

 

Regards,

Riyaz

Code Snippet

SELECT DISTINCT papf.person_number,
         uspn.display_name person_name,
         paaf.assignment_status_type,
         p.effective_date,
         flv.meaning employee_category,
         pd.name department,
         pldv.location_name,
         p.payroll_action_id,
         SUM (CASE WHEN b.balance_name = 'Personal Loan' THEN NVL (bal.balance_value, 0) ELSE .00 END) "Personal Loan Paid",