[Home] [Help]
363: IS
364: CURSOR c_process_assignments
365: IS
366: SELECT paf.assignment_id assignment_id
367: FROM per_assignments_f paf
368: ,pay_payroll_actions ppa
369: ,pay_assignment_actions paa
370: WHERE paf.business_group_id = g_bg_id
371: AND paf.person_id BETWEEN p_start_person AND p_end_person
381: AND ppa.business_group_id =g_bg_id
382: UNION
383: SELECT paf1.assignment_id
384: FROM pay_element_entries_f pee
385: ,per_assignments_f paf1
386: WHERE paf1.business_group_id = g_bg_id
387: AND paf1.person_id BETWEEN p_start_person AND p_end_person
388: AND pee.element_type_id = g_chln_element_id
389: AND p_payroll_action_id IS NOT NULL
716: CURSOR c_pos(p_person_id NUMBER)
717: IS
718: SELECT nvl(pos.name,job.name) name
719: FROM per_positions pos
720: ,per_assignments_f asg
721: ,per_jobs job
722: WHERE asg.position_id=pos.position_id(+)
723: AND asg.job_id=job.job_id(+)
724: AND asg.person_id = p_person_id
750:
751: CURSOR c_rep_address(p_person_id NUMBER)
752: IS
753: SELECT hou.location_id rep_location
754: FROM per_assignments_f asg
755: ,hr_organization_units hou
756: WHERE asg.person_id = p_person_id
757: AND asg.primary_flag = 'Y'
758: AND asg.business_group_id = g_bg_id
986: SELECT asg.person_id person_id
987: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
988: ,pep.per_information14 pan_ref_num
989: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) name
990: FROM per_assignments_f asg
991: ,per_people_f pep
992: WHERE asg.assignment_id = p_assignment_id
993: AND pep.person_id = asg.person_id
994: AND pep.business_group_id = g_bg_id
999: CURSOR c_pos
1000: IS
1001: SELECT nvl(pos.name,job.name) name
1002: FROM per_all_positions pos
1003: ,per_assignments_f asg
1004: ,per_jobs job
1005: WHERE asg.position_id=pos.position_id(+)
1006: AND asg.job_id=job.job_id(+)
1007: AND asg.assignment_id = p_assignment_id
1014: CURSOR c_aei_tax_rate(p_person_id NUMBER)
1015: IS
1016: SELECT paei.aei_information2
1017: FROM per_assignment_extra_info paei
1018: ,per_assignments_f paa
1019: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
1020: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
1021: AND paei.assignment_id = paa.assignment_id
1022: AND paa.person_id = p_person_id
2294: SELECT asg.person_id person_id
2295: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
2296: ,pep.per_information14 pan_ref_num
2297: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) name
2298: FROM per_assignments_f asg
2299: ,per_people_f pep
2300: WHERE asg.assignment_id = p_assignment_id
2301: AND pep.person_id = asg.person_id
2302: AND pep.business_group_id = g_bg_id
2307: CURSOR c_pos
2308: IS
2309: SELECT nvl(pos.name,job.name) name
2310: FROM per_all_positions pos
2311: ,per_assignments_f asg
2312: ,per_jobs job
2313: WHERE asg.position_id=pos.position_id(+)
2314: AND asg.job_id=job.job_id(+)
2315: AND asg.assignment_id = p_assignment_id
2322: CURSOR c_aei_tax_rate(p_person_id NUMBER)
2323: IS
2324: SELECT paei.aei_information2
2325: FROM per_assignment_extra_info paei
2326: ,per_assignments_f paa
2327: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
2328: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
2329: AND paei.assignment_id = paa.assignment_id
2330: AND paa.person_id = p_person_id
2541: IS
2542: SELECT GREATEST(asg.effective_start_date,g_fin_start_date) start_date
2543: ,LEAST(asg.effective_end_date,g_fin_end_date) end_date
2544: ,scl.segment1
2545: FROM per_assignments_f asg
2546: ,hr_soft_coding_keyflex scl
2547: ,pay_assignment_actions paa
2548: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2549: AND paa.assignment_action_id = p_assignment_action_id
2570: IS
2571: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
2572: FROM pay_assignment_actions paa
2573: ,pay_payroll_actions ppa
2574: ,per_assignments_f paf
2575: WHERE paf.assignment_id = paa.assignment_id
2576: AND paf.assignment_id = p_assignment_id
2577: AND paa.tax_unit_id = p_tax_unit_id
2578: AND paa.payroll_action_id = ppa.payroll_action_id