APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on PER_ASSIGNMENTS_F

Line 621: from per_assignments_f paa

617: and pai_comp.action_information6 = p_emp_ref;
618:
619: cursor asg_no is
620: select paa.assignment_number
621: from per_assignments_f paa
622: where paa.assignment_id = l_asg_id
623: and paa.effective_end_date = (select max(paa2.effective_end_date)
624: from per_assignments_f paa2
625: where paa2.assignment_id = l_asg_id);

Line 624: from per_assignments_f paa2

620: select paa.assignment_number
621: from per_assignments_f paa
622: where paa.assignment_id = l_asg_id
623: and paa.effective_end_date = (select max(paa2.effective_end_date)
624: from per_assignments_f paa2
625: where paa2.assignment_id = l_asg_id);
626:
627: cursor emp_no is
628: select employee_number

Line 5649: FROM per_assignments_f paf,

5645: -- Added paf.ASSIGNMENT_TYPE as we need to write primary assign number in
5646: -- magtape if the primary and sec both have the p11d benefits
5647: -- In case if only secondary have benefits then we may write
5648: -- any secondary assignment number in the magtape
5649: FROM per_assignments_f paf,
5650: pay_assignment_actions paa,
5651: pay_action_information pai_comp
5652: WHERE paf.person_id = p_person_id
5653: AND paa.assignment_id = paf.assignment_id

Line 5665: FROM per_assignments_f paf,

5661: CURSOR sum_marors_values
5662: IS
5663: SELECT /*+ ordered */
5664: SUM (TO_NUMBER (NVL (pai.action_information7, '0')))
5665: FROM per_assignments_f paf,
5666: pay_assignment_actions paa,
5667: pay_action_information pai_comp,
5668: pay_action_information pai
5669: WHERE paf.person_id = p_person_id