APPS.PAY_ZA_NOP_PERSON_LEVEL dependencies on PER_ALL_ASSIGNMENTS_F

Line 8: per_all_assignments_f pasf

4:
5: cursor csr_person is
6: select 1
7: from per_all_people_f papf,
8: per_all_assignments_f pasf
9: where papf.effective_end_date >= to_date('01/03/2010','DD/MM/YYYY')
10: and papf.person_id = p_person_id
11: and papf.business_group_id in (select business_group_id
12: from per_business_groups

Line 37: from PER_ASSIGNMENT_EXTRA_INFO pei, per_all_assignments_f pasf, per_all_people_f papf

33: PROCEDURE populate_nop(p_person_id number) AS
34:
35: cursor csr_asg_nop is
36: select pei.AEI_INFORMATION4
37: from PER_ASSIGNMENT_EXTRA_INFO pei, per_all_assignments_f pasf, per_all_people_f papf
38: where papf.person_id = p_person_id
39: and papf.person_id = pasf.person_id
40: and pasf.assignment_id = pei.assignment_id
41: and pasf.primary_flag = 'Y'