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_AE_SI_REPORTS dependencies on PER_ALL_PEOPLE_F

Line 132: FROM per_phones pp,per_all_people_f ppf

128:
129: /* Cursor for fetching person's phone details */
130: CURSOR csr_p_phone_data (l_person_id number,l_ph_type varchar2,l_effective_date date) IS
131: SELECT pp.phone_number
132: FROM per_phones pp,per_all_people_f ppf
133: WHERE pp.parent_id = ppf.person_id
134: AND pp.phone_type = l_ph_type
135: AND ppf.person_id = l_person_id
136: AND l_effective_date between pp.date_from and nvl(pp.date_to,to_date('31-12-4712','DD-MM-YYYY'));

Line 149: ,per_all_people_f ppf

145: ,pay_assignment_actions paa
146: ,pay_payroll_actions ppa
147: ,hr_soft_coding_keyflex hscl
148: ,per_periods_of_service pos
149: ,per_all_people_f ppf
150: WHERE asg.assignment_id = paa.assignment_id
151: AND paa.payroll_action_id = ppa.payroll_action_id
152: AND pos.period_of_service_id = asg.period_of_service_id
153: AND ppa.action_type in ('R','Q')

Line 168: FROM per_all_people_f ppf

164:
165: /* Cursor for fetching the person data */
166: CURSOR csr_p_data (l_person_id number,l_effective_date date) IS
167: SELECT ppf.full_name,ppf.employee_number,ppf.date_of_birth,ppf.marital_status,ppf.sex,fnd_date.canonical_to_date(ppf.per_information16),ppf.per_information17
168: FROM per_all_people_f ppf
169: WHERE ppf.person_id = l_person_id
170: AND l_effective_date between ppf.effective_start_date and ppf.effective_end_date;
171:
172: /* Cursor for fetching the person's gender meaning */

Line 299: FROM per_contact_relationships cont , per_all_people_f ppf

295:
296: /* Cursor for fetching person's contact counts */
297: CURSOR csr_p_contact_count_data (l_person_id number,l_type varchar2, l_gender varchar2, l_effective_date date) IS
298: SELECT count(*)
299: FROM per_contact_relationships cont , per_all_people_f ppf
300: WHERE cont.person_id = l_person_id
301: AND cont.contact_type = l_type
302: AND ppf.person_id = cont.CONTACT_PERSON_ID
303: AND ppf.sex = l_gender

Line 1251: FROM per_phones pp,per_all_people_f ppf

1247:
1248: /* Cursor for fetching person's phone details */
1249: CURSOR csr_p_phone_data (l_person_id number,l_ph_type varchar2,l_effective_date date) IS
1250: SELECT pp.phone_number
1251: FROM per_phones pp,per_all_people_f ppf
1252: WHERE pp.parent_id = ppf.person_id
1253: AND pp.phone_type = l_ph_type
1254: AND ppf.person_id = l_person_id
1255: AND l_effective_date between pp.date_from and nvl(pp.date_to,to_date('31-12-4712','DD-MM-YYYY'));

Line 1277: ,per_all_people_f ppf

1273: ,pay_assignment_actions paa
1274: ,pay_payroll_actions ppa
1275: ,hr_soft_coding_keyflex hscl
1276: ,per_periods_of_service pos
1277: ,per_all_people_f ppf
1278: WHERE asg.assignment_id = paa.assignment_id
1279: AND paa.payroll_action_id = ppa.payroll_action_id
1280: AND pos.period_of_service_id = asg.period_of_service_id
1281: AND ppa.action_type in ('R','Q')

Line 1303: FROM per_all_people_f ppf

1299:
1300: /* Cursor for fetching the person data */
1301: CURSOR csr_p_data (l_person_id number,l_effective_date date) IS
1302: SELECT ppf.full_name,ppf.marital_status,ppf.sex
1303: FROM per_all_people_f ppf
1304: WHERE ppf.person_id = l_person_id
1305: AND l_effective_date between ppf.effective_start_date and ppf.effective_end_date;
1306:
1307: /* Cursor for fetching the person's marital status */

Line 1327: FROM per_contact_relationships cont , per_all_people_f ppf

1323:
1324: /* Cursor for fetching person's contact counts */
1325: CURSOR csr_p_contact_count_data (l_person_id number,l_type varchar2, l_gender varchar2, l_effective_date date) IS
1326: SELECT count(*)
1327: FROM per_contact_relationships cont , per_all_people_f ppf
1328: WHERE cont.person_id = l_person_id
1329: AND cont.contact_type = l_type
1330: AND ppf.person_id = cont.CONTACT_PERSON_ID
1331: AND ppf.sex = l_gender

Line 2110: ,per_all_people_f ppf

2106: ,pay_assignment_actions paa
2107: ,pay_payroll_actions ppa
2108: ,hr_soft_coding_keyflex hscl
2109: ,per_periods_of_service pos
2110: ,per_all_people_f ppf
2111: WHERE asg.assignment_id = paa.assignment_id
2112: AND paa.payroll_action_id = ppa.payroll_action_id
2113: AND pos.period_of_service_id = asg.period_of_service_id
2114: AND ppa.action_type in ('R','Q')

Line 2128: FROM per_all_people_f ppf

2124:
2125: /* Cursor for fetching the person data */
2126: CURSOR csr_get_person_data (l_person_id number,l_effective_date date) IS
2127: SELECT ppf.full_name
2128: FROM per_all_people_f ppf
2129: WHERE ppf.person_id = l_person_id
2130: AND l_effective_date between ppf.effective_start_date and ppf.effective_end_date;
2131:
2132: /* Cursor for fetching the person's assignment data */

Line 2635: ,per_all_people_f ppf

2631: ,pay_assignment_actions paa
2632: ,pay_payroll_actions ppa
2633: ,hr_soft_coding_keyflex hscl
2634: ,per_periods_of_service pos
2635: ,per_all_people_f ppf
2636: WHERE asg.assignment_id = paa.assignment_id
2637: AND paa.payroll_action_id = ppa.payroll_action_id
2638: AND pos.period_of_service_id = asg.period_of_service_id
2639: AND ppa.action_type in ('R','Q')

Line 2664: ,per_all_people_f ppf

2660: ,pay_assignment_actions paa
2661: ,pay_payroll_actions ppa
2662: ,hr_soft_coding_keyflex hscl
2663: ,per_periods_of_service pos
2664: ,per_all_people_f ppf
2665: WHERE asg.assignment_id = paa.assignment_id
2666: AND paa.payroll_action_id = ppa.payroll_action_id
2667: AND pos.period_of_service_id = asg.period_of_service_id
2668: AND ppa.action_type in ('R','Q')

Line 2710: ,per_all_people_f ppf

2706: ,pay_assignment_actions paa
2707: ,pay_payroll_actions ppa
2708: ,hr_soft_coding_keyflex hscl
2709: ,per_periods_of_service pos
2710: ,per_all_people_f ppf
2711: WHERE asg.assignment_id = paa.assignment_id
2712: AND paa.payroll_action_id = ppa.payroll_action_id
2713: AND pos.period_of_service_id = asg.period_of_service_id
2714: AND ppa.action_type in ('R','Q')

Line 2732: FROM per_all_people_f ppf

2728:
2729: /* Cursor for fetching the person data */
2730: CURSOR csr_get_person_data (l_person_id number,l_effective_date date) IS
2731: SELECT ppf.full_name
2732: FROM per_all_people_f ppf
2733: WHERE ppf.person_id = l_person_id
2734: AND l_effective_date between ppf.effective_start_date and ppf.effective_end_date;
2735:
2736: /* Cursor for fetching the person's assignment data */

Line 3813: ,per_all_people_f ppf

3809: ,pay_assignment_actions paa
3810: ,pay_payroll_actions ppa
3811: ,hr_soft_coding_keyflex hscl
3812: ,per_periods_of_service pos
3813: ,per_all_people_f ppf
3814: WHERE asg.assignment_id = paa.assignment_id
3815: AND paa.payroll_action_id = ppa.payroll_action_id
3816: AND pos.period_of_service_id = asg.period_of_service_id
3817: AND ppa.action_type in ('R','Q')

Line 3831: FROM per_all_people_f ppf

3827:
3828: /* Cursor for fetching the person data */
3829: CURSOR csr_get_person_data (l_person_id number,l_effective_date date) IS
3830: SELECT ppf.full_name, ppf.employee_number
3831: FROM per_all_people_f ppf
3832: WHERE ppf.person_id = l_person_id
3833: AND l_effective_date between ppf.effective_start_date and ppf.effective_end_date;
3834:
3835: /* Cursor for fetching the person's assignment data */

Line 4583: ,per_all_people_f ppf

4579: ,pay_assignment_actions paa
4580: ,pay_payroll_actions ppa
4581: ,hr_soft_coding_keyflex hscl
4582: ,per_periods_of_service pos
4583: ,per_all_people_f ppf
4584: WHERE asg.assignment_id = paa.assignment_id
4585: AND paa.payroll_action_id = ppa.payroll_action_id
4586: AND pos.period_of_service_id = asg.period_of_service_id
4587: AND ppa.action_type in ('R','Q')

Line 4601: FROM per_all_people_f ppf

4597:
4598: /* Cursor for fetching the person data */
4599: CURSOR csr_get_person_data (l_person_id number,l_effective_date date) IS
4600: SELECT ppf.full_name, ppf.employee_number
4601: FROM per_all_people_f ppf
4602: WHERE ppf.person_id = l_person_id
4603: AND l_effective_date between ppf.effective_start_date and ppf.effective_end_date;
4604:
4605: /* Cursor for fetching the person's assignment data */