APPS.PAY_IN_24Q_ARCHIVE dependencies on PER_PEOPLE_F

Line 739: ,per_people_f pep

735: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) rep_name
736: ,pep.email_address email_id
737: FROM hr_organization_information hoi
738: ,hr_organization_units hou
739: ,per_people_f pep
740: WHERE hoi.org_information_context = 'PER_IN_INCOME_TAX_REP_DF'
741: AND hoi.organization_id = p_gre_id
742: AND hou.organization_id = hoi.organization_id
743: AND hou.business_group_id = g_bg_id

Line 991: ,per_people_f pep

987: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
988: ,pep.per_information14 pan_ref_num
989: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) name
990: FROM per_assignments_f asg
991: ,per_people_f pep
992: WHERE asg.assignment_id = p_assignment_id
993: AND pep.person_id = asg.person_id
994: AND pep.business_group_id = g_bg_id
995: AND asg.business_group_id = g_bg_id

Line 2299: ,per_people_f pep

2295: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
2296: ,pep.per_information14 pan_ref_num
2297: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) name
2298: FROM per_assignments_f asg
2299: ,per_people_f pep
2300: WHERE asg.assignment_id = p_assignment_id
2301: AND pep.person_id = asg.person_id
2302: AND pep.business_group_id = g_bg_id
2303: AND asg.business_group_id = g_bg_id