APPS.PAY_IN_24QC_ARCHIVE dependencies on PER_PEOPLE_F

Line 1174: ,per_people_f pep

1170: ,pai.action_context_id last_action_context_id
1171: ,pep.effective_end_date
1172: FROM pay_action_information pai
1173: ,pay_assignment_actions paa
1174: ,per_people_f pep
1175: ,per_assignments_f asg
1176: WHERE pai.action_information_category = 'IN_24Q_DEDUCTEE'
1177: AND pai.action_context_id = paa.assignment_action_id
1178: AND pai.action_information3 = g_gre_id

Line 1269: ,per_people_f pep

1265: )
1266: IS
1267: SELECT pai.action_context_id
1268: FROM pay_action_information pai
1269: ,per_people_f pep
1270: ,per_assignments_f asg
1271: ,pay_assignment_actions paa
1272: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
1273: AND paa.assignment_action_id = pai.action_context_id

Line 1339: ,per_people_f pep

1335: AND NOT EXISTS
1336: (
1337: SELECT 1
1338: FROM pay_action_information pai
1339: ,per_people_f pep
1340: ,per_assignments_f asg
1341: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
1342: AND pai.source_id = p_element_entry_id
1343: AND pai.action_information3 = g_gre_id

Line 2060: ,per_people_f pep

2056: ,pai.action_context_id last_action_context_id
2057: ,pep.effective_end_date
2058: FROM pay_action_information pai
2059: ,pay_assignment_actions paa
2060: ,per_people_f pep
2061: ,per_assignments_f asg
2062: WHERE pai.action_information_category = 'IN_24Q_PERSON'
2063: AND fnd_number.canonical_to_number(pai.action_information1)
2064: BETWEEN p_start_person AND p_end_person

Line 2227: ,per_people_f pep

2223: )
2224: IS
2225: SELECT pai.action_context_id
2226: FROM pay_action_information pai
2227: ,per_people_f pep
2228: ,per_assignments_f asg
2229: ,pay_assignment_actions paa
2230: WHERE pai.action_information_category = 'IN_24QC_PERSON'
2231: AND fnd_number.canonical_to_number(pai.action_information1)

Line 2371: ,per_people_f pep

2367: AND NOT EXISTS
2368: (
2369: SELECT 1
2370: FROM pay_action_information pai
2371: ,per_people_f pep
2372: ,per_assignments_f asg
2373: WHERE pai.action_information_category = 'IN_24QC_PERSON'
2374: AND fnd_number.canonical_to_number(pai.action_information1)
2375: BETWEEN p_start_person AND p_end_person

Line 2905: ,per_people_f pep

2901: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) rep_name
2902: ,pep.email_address email_id
2903: FROM hr_organization_information hoi
2904: ,hr_organization_units hou
2905: ,per_people_f pep
2906: WHERE hoi.org_information_context = 'PER_IN_INCOME_TAX_REP_DF'
2907: AND hoi.organization_id = p_gre_id
2908: AND hou.organization_id = hoi.organization_id
2909: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 4211: ,per_people_f pep

4207: ,pep.per_information14 pan_ref_number
4208: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) full_name
4209: ,pep.effective_end_date
4210: FROM per_assignments_f asg
4211: ,per_people_f pep
4212: WHERE asg.assignment_id = p_assignment_id
4213: AND pep.person_id = asg.person_id
4214: AND pep.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
4215: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 4629: ,per_people_f pep

4625: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
4626: ,pep.per_information14 pan_ref_number
4627: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) full_name
4628: FROM per_assignments_f asg
4629: ,per_people_f pep
4630: WHERE asg.assignment_id = p_assignment_id
4631: AND pep.person_id = asg.person_id
4632: AND pep.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
4633: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')