APPS.PAY_IN_24Q_ARCHIVE dependencies on PER_PEOPLE_F

Line 712: ,per_people_f pep

708: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) rep_name
709: ,pep.email_address email_id
710: FROM hr_organization_information hoi
711: ,hr_organization_units hou
712: ,per_people_f pep
713: WHERE hoi.org_information_context = 'PER_IN_INCOME_TAX_REP_DF'
714: AND hoi.organization_id = p_gre_id
715: AND hou.organization_id = hoi.organization_id
716: AND hou.business_group_id = g_bg_id

Line 910: ,per_people_f pep

906: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
907: ,pep.per_information14 pan_ref_num
908: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) name
909: FROM per_assignments_f asg
910: ,per_people_f pep
911: WHERE asg.assignment_id = p_assignment_id
912: AND pep.person_id = asg.person_id
913: AND pep.business_group_id = g_bg_id
914: AND asg.business_group_id = g_bg_id

Line 2193: ,per_people_f pep

2189: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
2190: ,pep.per_information14 pan_ref_num
2191: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) name
2192: FROM per_assignments_f asg
2193: ,per_people_f pep
2194: WHERE asg.assignment_id = p_assignment_id
2195: AND pep.person_id = asg.person_id
2196: AND pep.business_group_id = g_bg_id
2197: AND asg.business_group_id = g_bg_id