689: OPEN csr_person_details (g_business_group_id);
690: FETCH csr_person_details INTO lr_person_details;
691: CLOSE csr_person_details;
692: -- l_employee_pin := lr_person_details.national_identifier;
693: pay_balance_pkg.set_context ('TAX_UNIT_ID', g_legal_employer_id);
694: pay_balance_pkg.set_context (
695: 'DATE_EARNED',
696: fnd_date.date_to_canonical (g_pay_period_end_date)
697: );
690: FETCH csr_person_details INTO lr_person_details;
691: CLOSE csr_person_details;
692: -- l_employee_pin := lr_person_details.national_identifier;
693: pay_balance_pkg.set_context ('TAX_UNIT_ID', g_legal_employer_id);
694: pay_balance_pkg.set_context (
695: 'DATE_EARNED',
696: fnd_date.date_to_canonical (g_pay_period_end_date)
697: );
698: pay_balance_pkg.set_context ('JURISDICTION_CODE', NULL);
694: pay_balance_pkg.set_context (
695: 'DATE_EARNED',
696: fnd_date.date_to_canonical (g_pay_period_end_date)
697: );
698: pay_balance_pkg.set_context ('JURISDICTION_CODE', NULL);
699: pay_balance_pkg.set_context (
700: 'ASSIGNMENT_ID',
701: lr_person_details.assignment_id
702: );
695: 'DATE_EARNED',
696: fnd_date.date_to_canonical (g_pay_period_end_date)
697: );
698: pay_balance_pkg.set_context ('JURISDICTION_CODE', NULL);
699: pay_balance_pkg.set_context (
700: 'ASSIGNMENT_ID',
701: lr_person_details.assignment_id
702: );
703: pay_balance_pkg.set_context ('SOURCE_ID', NULL);
699: pay_balance_pkg.set_context (
700: 'ASSIGNMENT_ID',
701: lr_person_details.assignment_id
702: );
703: pay_balance_pkg.set_context ('SOURCE_ID', NULL);
704: pay_balance_pkg.set_context ('TAX_GROUP', NULL);
705: /* OPEN csr_Get_Defined_Balance_Id( 'BENEFITS_IN_KIND_PER_LE_PTD');
706: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
707: CLOSE csr_Get_Defined_Balance_Id;
700: 'ASSIGNMENT_ID',
701: lr_person_details.assignment_id
702: );
703: pay_balance_pkg.set_context ('SOURCE_ID', NULL);
704: pay_balance_pkg.set_context ('TAX_GROUP', NULL);
705: /* OPEN csr_Get_Defined_Balance_Id( 'BENEFITS_IN_KIND_PER_LE_PTD');
706: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
707: CLOSE csr_Get_Defined_Balance_Id;
708:
705: /* OPEN csr_Get_Defined_Balance_Id( 'BENEFITS_IN_KIND_PER_LE_PTD');
706: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
707: CLOSE csr_Get_Defined_Balance_Id;
708:
709: l_benefits :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ID =>lr_person_details.assignment_id , P_VIRTUAL_DATE => g_pay_period_end_date );
710: fnd_file.put_line (
711: fnd_file.LOG,
712: ' l_benefits'||l_benefits
713:
890: || lr_get_run_ass_action_id
891: );
892:
893:
894: RETURN (pay_balance_pkg.get_value (
895: p_defined_balance_id=> lr_get_defined_balance_id,
896: p_assignment_action_id=> lr_get_run_ass_action_id
897: )
898: );