eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_24QC_ARCHIVE dependencies on PER_PEOPLE_F

Line 1067: ,per_people_f pep

1063: ,pai.action_context_id last_action_context_id
1064: ,pep.effective_end_date
1065: FROM pay_action_information pai
1066: ,pay_assignment_actions paa
1067: ,per_people_f pep
1068: ,per_assignments_f asg
1069: WHERE pai.action_information_category = 'IN_24Q_DEDUCTEE'
1070: AND pai.action_context_id = paa.assignment_action_id
1071: AND pai.action_information3 = g_gre_id

Line 1162: ,per_people_f pep

1158: )
1159: IS
1160: SELECT pai.action_context_id
1161: FROM pay_action_information pai
1162: ,per_people_f pep
1163: ,per_assignments_f asg
1164: ,pay_assignment_actions paa
1165: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
1166: AND paa.assignment_action_id = pai.action_context_id

Line 1232: ,per_people_f pep

1228: AND NOT EXISTS
1229: (
1230: SELECT 1
1231: FROM pay_action_information pai
1232: ,per_people_f pep
1233: ,per_assignments_f asg
1234: WHERE pai.action_information_category = 'IN_24QC_DEDUCTEE'
1235: AND pai.source_id = p_element_entry_id
1236: AND pai.action_information3 = g_gre_id

Line 1953: ,per_people_f pep

1949: ,pai.action_context_id last_action_context_id
1950: ,pep.effective_end_date
1951: FROM pay_action_information pai
1952: ,pay_assignment_actions paa
1953: ,per_people_f pep
1954: ,per_assignments_f asg
1955: WHERE pai.action_information_category = 'IN_24Q_PERSON'
1956: AND fnd_number.canonical_to_number(pai.action_information1)
1957: BETWEEN p_start_person AND p_end_person

Line 2120: ,per_people_f pep

2116: )
2117: IS
2118: SELECT pai.action_context_id
2119: FROM pay_action_information pai
2120: ,per_people_f pep
2121: ,per_assignments_f asg
2122: ,pay_assignment_actions paa
2123: WHERE pai.action_information_category = 'IN_24QC_PERSON'
2124: AND fnd_number.canonical_to_number(pai.action_information1)

Line 2264: ,per_people_f pep

2260: AND NOT EXISTS
2261: (
2262: SELECT 1
2263: FROM pay_action_information pai
2264: ,per_people_f pep
2265: ,per_assignments_f asg
2266: WHERE pai.action_information_category = 'IN_24QC_PERSON'
2267: AND fnd_number.canonical_to_number(pai.action_information1)
2268: BETWEEN p_start_person AND p_end_person

Line 2783: ,per_people_f pep

2779: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) rep_name
2780: ,pep.email_address email_id
2781: FROM hr_organization_information hoi
2782: ,hr_organization_units hou
2783: ,per_people_f pep
2784: WHERE hoi.org_information_context = 'PER_IN_INCOME_TAX_REP_DF'
2785: AND hoi.organization_id = p_gre_id
2786: AND hou.organization_id = hoi.organization_id
2787: AND hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 3887: ,per_people_f pep

3883: ,pep.per_information14 pan_ref_number
3884: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) full_name
3885: ,pep.effective_end_date
3886: FROM per_assignments_f asg
3887: ,per_people_f pep
3888: WHERE asg.assignment_id = p_assignment_id
3889: AND pep.person_id = asg.person_id
3890: AND pep.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
3891: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 4305: ,per_people_f pep

4301: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
4302: ,pep.per_information14 pan_ref_number
4303: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) full_name
4304: FROM per_assignments_f asg
4305: ,per_people_f pep
4306: WHERE asg.assignment_id = p_assignment_id
4307: AND pep.person_id = asg.person_id
4308: AND pep.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
4309: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')