APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on PER_ASSIGNMENTS_F

Line 629: from per_assignments_f paa

625: and pai_comp.action_information6 = p_emp_ref;
626:
627: cursor asg_no is
628: select paa.assignment_number
629: from per_assignments_f paa
630: where paa.assignment_id = l_asg_id
631: and paa.effective_end_date = (select max(paa2.effective_end_date)
632: from per_assignments_f paa2
633: where paa2.assignment_id = l_asg_id);

Line 632: from per_assignments_f paa2

628: select paa.assignment_number
629: from per_assignments_f paa
630: where paa.assignment_id = l_asg_id
631: and paa.effective_end_date = (select max(paa2.effective_end_date)
632: from per_assignments_f paa2
633: where paa2.assignment_id = l_asg_id);
634:
635: cursor emp_no is
636: select employee_number

Line 6527: FROM per_assignments_f paf,

6523: -- Added paf.ASSIGNMENT_TYPE as we need to write primary assign number in
6524: -- magtape if the primary and sec both have the p11d benefits
6525: -- In case if only secondary have benefits then we may write
6526: -- any secondary assignment number in the magtape
6527: FROM per_assignments_f paf,
6528: pay_assignment_actions paa,
6529: pay_action_information pai_comp
6530: WHERE paf.person_id = p_person_id
6531: AND paa.assignment_id = paf.assignment_id

Line 6543: FROM per_assignments_f paf,

6539: CURSOR sum_marors_values
6540: IS
6541: SELECT /*+ ordered */
6542: SUM (TO_NUMBER (NVL (pai.action_information7, '0')))
6543: FROM per_assignments_f paf,
6544: pay_assignment_actions paa,
6545: pay_action_information pai_comp,
6546: pay_action_information pai
6547: WHERE paf.person_id = p_person_id