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_ASSIGNMENTS_F

Line 144: FROM per_all_assignments_f asg

140: SELECT distinct asg.person_id
141: ,paa.assignment_action_id
142: ,ppa.date_earned
143: ,pos.date_start
144: FROM per_all_assignments_f asg
145: ,pay_assignment_actions paa
146: ,pay_payroll_actions ppa
147: ,hr_soft_coding_keyflex hscl
148: ,per_periods_of_service pos

Line 191: FROM per_all_assignments_f paf,hr_soft_coding_keyflex hsck

187:
188: /* Cursor for fetching the person's assignment data */
189: CURSOR csr_p_asg_data (l_person_id number,l_effective_date date) IS
190: SELECT hsck.segment2,hsck.segment3,fnd_date.canonical_to_date(hsck.segment4),hsck.segment5,paf.location_id
191: FROM per_all_assignments_f paf,hr_soft_coding_keyflex hsck
192: WHERE paf.person_id = l_person_id
193: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
194: AND hsck.segment1 = p_employer_id
195: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 200: FROM per_all_assignments_f paf,per_jobs pjb

196:
197: /* Cursor for fetching the person's job */
198: CURSOR csr_p_job (l_person_id number,l_effective_date date) IS
199: SELECT pjb.name
200: FROM per_all_assignments_f paf,per_jobs pjb
201: WHERE paf.person_id = l_person_id
202: AND pjb.job_id = paf.job_id
203: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;
204:

Line 1272: FROM per_all_assignments_f asg

1268: ,paa.assignment_action_id
1269: ,pos.actual_termination_date
1270: ,pos.LEAVING_REASON
1271: ,ppa.date_earned
1272: FROM per_all_assignments_f asg
1273: ,pay_assignment_actions paa
1274: ,pay_payroll_actions ppa
1275: ,hr_soft_coding_keyflex hscl
1276: ,per_periods_of_service pos

Line 1318: FROM per_all_assignments_f paf,hr_soft_coding_keyflex hsck

1314:
1315: /* Cursor for fetching the person's assignment data */
1316: CURSOR csr_p_asg_data (l_person_id number,l_effective_date date) IS
1317: SELECT paf.assignment_id , hsck.segment3,paf.location_id
1318: FROM per_all_assignments_f paf,hr_soft_coding_keyflex hsck
1319: WHERE paf.person_id = l_person_id
1320: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
1321: AND hsck.segment1 = p_employer_id
1322: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 2105: FROM per_all_assignments_f asg

2101: CURSOR csr_get_emp (l_employer number , l_date date , l_nat_cd varchar2) IS
2102: SELECT distinct asg.person_id
2103: ,paa.assignment_action_id
2104: ,ppa.date_earned
2105: FROM per_all_assignments_f asg
2106: ,pay_assignment_actions paa
2107: ,pay_payroll_actions ppa
2108: ,hr_soft_coding_keyflex hscl
2109: ,per_periods_of_service pos

Line 2135: FROM per_all_assignments_f paf,hr_soft_coding_keyflex hsck

2131:
2132: /* Cursor for fetching the person's assignment data */
2133: CURSOR csr_get_person_asg_data (l_person_id number,l_effective_date date) IS
2134: SELECT hsck.segment3
2135: FROM per_all_assignments_f paf,hr_soft_coding_keyflex hsck
2136: WHERE paf.person_id = l_person_id
2137: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
2138: AND hsck.segment1 = p_employer_id
2139: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 2630: FROM per_all_assignments_f asg

2626: CURSOR csr_get_new_emp (l_effective_date date, l_nat_cd varchar2) IS
2627: SELECT distinct asg.person_id
2628: ,paa.assignment_action_id
2629: ,pos.date_start
2630: FROM per_all_assignments_f asg
2631: ,pay_assignment_actions paa
2632: ,pay_payroll_actions ppa
2633: ,hr_soft_coding_keyflex hscl
2634: ,per_periods_of_service pos

Line 2659: FROM per_all_assignments_f asg

2655: SELECT distinct asg.person_id
2656: ,paa.assignment_action_id
2657: ,pos.actual_termination_date
2658: ,ppa.date_earned
2659: FROM per_all_assignments_f asg
2660: ,pay_assignment_actions paa
2661: ,pay_payroll_actions ppa
2662: ,hr_soft_coding_keyflex hscl
2663: ,per_periods_of_service pos

Line 2684: FROM per_all_assignments_f asg

2680: rec_get_ter_emp csr_get_ter_emp%ROWTYPE;
2681: /*Cursor for fetching effective date of salary change*/
2682: CURSOR csr_get_salary_date (p_person_id NUMBER, l_effective_date date) IS
2683: SELECT date_earned, paa.assignment_action_id
2684: FROM per_all_assignments_f asg
2685: ,pay_assignment_actions paa
2686: ,pay_payroll_actions ppa
2687: ,per_periods_of_service pos
2688: WHERE asg.assignment_id = paa.assignment_id

Line 2705: FROM per_all_assignments_f asg

2701: CURSOR csr_get_cha_emp(l_effective_date date, l_nat_cd varchar2) IS
2702: SELECT distinct asg.person_id
2703: ,paa.assignment_action_id
2704: ,date_earned
2705: FROM per_all_assignments_f asg
2706: ,pay_assignment_actions paa
2707: ,pay_payroll_actions ppa
2708: ,hr_soft_coding_keyflex hscl
2709: ,per_periods_of_service pos

Line 2739: FROM per_all_assignments_f paf,hr_soft_coding_keyflex hsck

2735:
2736: /* Cursor for fetching the person's assignment data */
2737: CURSOR csr_get_person_asg_data (l_person_id number,l_effective_date date) IS
2738: SELECT hsck.segment3
2739: FROM per_all_assignments_f paf,hr_soft_coding_keyflex hsck
2740: WHERE paf.person_id = l_person_id
2741: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
2742: AND hsck.segment1 = p_employer_id
2743: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 3808: FROM per_all_assignments_f asg

3804: CURSOR csr_get_emp (l_employer number , l_date date , l_nat_cd varchar2) IS
3805: SELECT distinct asg.person_id
3806: ,paa.assignment_action_id
3807: ,ppa.date_earned
3808: FROM per_all_assignments_f asg
3809: ,pay_assignment_actions paa
3810: ,pay_payroll_actions ppa
3811: ,hr_soft_coding_keyflex hscl
3812: ,per_periods_of_service pos

Line 3838: FROM per_all_assignments_f paf,hr_soft_coding_keyflex hsck

3834:
3835: /* Cursor for fetching the person's assignment data */
3836: CURSOR csr_get_person_asg_data (l_person_id number,l_effective_date date) IS
3837: SELECT hsck.segment3
3838: FROM per_all_assignments_f paf,hr_soft_coding_keyflex hsck
3839: WHERE paf.person_id = l_person_id
3840: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
3841: AND hsck.segment1 = p_employer_id
3842: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 4578: FROM per_all_assignments_f asg

4574: CURSOR csr_get_emp (l_employer number , l_date date , l_nat_cd varchar2) IS
4575: SELECT distinct asg.person_id
4576: ,paa.assignment_action_id
4577: ,ppa.date_earned
4578: FROM per_all_assignments_f asg
4579: ,pay_assignment_actions paa
4580: ,pay_payroll_actions ppa
4581: ,hr_soft_coding_keyflex hscl
4582: ,per_periods_of_service pos

Line 4608: FROM per_all_assignments_f paf,hr_soft_coding_keyflex hsck

4604:
4605: /* Cursor for fetching the person's assignment data */
4606: CURSOR csr_get_person_asg_data (l_person_id number,l_effective_date date) IS
4607: SELECT hsck.segment3
4608: FROM per_all_assignments_f paf,hr_soft_coding_keyflex hsck
4609: WHERE paf.person_id = l_person_id
4610: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
4611: AND hsck.segment1 = p_employer_id
4612: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;