[Home] [Help]
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
149: ,per_all_people_f ppf
150: WHERE asg.assignment_id = paa.assignment_id
151: AND paa.payroll_action_id = ppa.payroll_action_id
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;
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
1277: ,per_all_people_f ppf
1278: WHERE asg.assignment_id = paa.assignment_id
1279: AND paa.payroll_action_id = ppa.payroll_action_id
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;
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
2110: ,per_all_people_f ppf
2111: WHERE asg.assignment_id = paa.assignment_id
2112: AND paa.payroll_action_id = ppa.payroll_action_id
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;
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
2635: ,per_all_people_f ppf
2636: WHERE asg.assignment_id = paa.assignment_id
2637: AND paa.payroll_action_id = ppa.payroll_action_id
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
2664: ,per_all_people_f ppf
2665: WHERE asg.assignment_id = paa.assignment_id
2666: AND paa.payroll_action_id = ppa.payroll_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
2710: ,per_all_people_f ppf
2711: WHERE asg.assignment_id = paa.assignment_id
2712: AND paa.payroll_action_id = ppa.payroll_action_id
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;
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
3813: ,per_all_people_f ppf
3814: WHERE asg.assignment_id = paa.assignment_id
3815: AND paa.payroll_action_id = ppa.payroll_action_id
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;
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
4583: ,per_all_people_f ppf
4584: WHERE asg.assignment_id = paa.assignment_id
4585: AND paa.payroll_action_id = ppa.payroll_action_id
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;