DBA Data[Home] [Help]

APPS.PAY_ZA_NOP_PERSON_LEVEL dependencies on PER_ASSIGNMENT_EXTRA_INFO

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'