[Home] [Help]
364: IS
365: CURSOR c_process_assignments
366: IS
367: SELECT paf.assignment_id assignment_id
368: FROM per_assignments_f paf
369: ,pay_payroll_actions ppa
370: ,pay_assignment_actions paa
371: WHERE paf.business_group_id = g_bg_id
372: AND paf.person_id BETWEEN p_start_person AND p_end_person
382: AND ppa.business_group_id =g_bg_id
383: UNION
384: SELECT paf1.assignment_id
385: FROM pay_element_entries_f pee
386: ,per_assignments_f paf1
387: WHERE paf1.business_group_id = g_bg_id
388: AND paf1.person_id BETWEEN p_start_person AND p_end_person
389: AND pee.element_type_id = g_chln_element_id
390: AND p_payroll_action_id IS NOT NULL
689: CURSOR c_pos(p_person_id NUMBER)
690: IS
691: SELECT nvl(pos.name,job.name) name
692: FROM per_positions pos
693: ,per_assignments_f asg
694: ,per_jobs job
695: WHERE asg.position_id=pos.position_id(+)
696: AND asg.job_id=job.job_id(+)
697: AND asg.person_id = p_person_id
723:
724: CURSOR c_rep_address(p_person_id NUMBER)
725: IS
726: SELECT hou.location_id rep_location
727: FROM per_assignments_f asg
728: ,hr_organization_units hou
729: WHERE asg.person_id = p_person_id
730: AND asg.primary_flag = 'Y'
731: AND asg.business_group_id = g_bg_id
905: SELECT asg.person_id person_id
906: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
907: ,pep.per_information14 pan_ref_num
908: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) name
909: FROM per_assignments_f asg
910: ,per_people_f pep
911: WHERE asg.assignment_id = p_assignment_id
912: AND pep.person_id = asg.person_id
913: AND pep.business_group_id = g_bg_id
918: CURSOR c_pos
919: IS
920: SELECT nvl(pos.name,job.name) name
921: FROM per_all_positions pos
922: ,per_assignments_f asg
923: ,per_jobs job
924: WHERE asg.position_id=pos.position_id(+)
925: AND asg.job_id=job.job_id(+)
926: AND asg.assignment_id = p_assignment_id
933: CURSOR c_aei_tax_rate(p_person_id NUMBER)
934: IS
935: SELECT paei.aei_information2
936: FROM per_assignment_extra_info paei
937: ,per_assignments_f paa
938: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
939: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
940: AND paei.assignment_id = paa.assignment_id
941: AND paa.person_id = p_person_id
2188: SELECT asg.person_id person_id
2189: ,DECODE(pep.per_information4,NULL,DECODE(pep.per_information5,'Yes','APPLIEDFOR','PANNOTAVBL'),pep.per_information4) pan
2190: ,pep.per_information14 pan_ref_num
2191: ,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) name
2192: FROM per_assignments_f asg
2193: ,per_people_f pep
2194: WHERE asg.assignment_id = p_assignment_id
2195: AND pep.person_id = asg.person_id
2196: AND pep.business_group_id = g_bg_id
2201: CURSOR c_pos
2202: IS
2203: SELECT nvl(pos.name,job.name) name
2204: FROM per_all_positions pos
2205: ,per_assignments_f asg
2206: ,per_jobs job
2207: WHERE asg.position_id=pos.position_id(+)
2208: AND asg.job_id=job.job_id(+)
2209: AND asg.assignment_id = p_assignment_id
2216: CURSOR c_aei_tax_rate(p_person_id NUMBER)
2217: IS
2218: SELECT paei.aei_information2
2219: FROM per_assignment_extra_info paei
2220: ,per_assignments_f paa
2221: WHERE paei.information_type = 'PER_IN_TAX_EXEMPTION_DF'
2222: AND paei.aei_information_category = 'PER_IN_TAX_EXEMPTION_DF'
2223: AND paei.assignment_id = paa.assignment_id
2224: AND paa.person_id = p_person_id
2435: IS
2436: SELECT GREATEST(asg.effective_start_date,g_fin_start_date) start_date
2437: ,LEAST(asg.effective_end_date,g_fin_end_date) end_date
2438: ,scl.segment1
2439: FROM per_assignments_f asg
2440: ,hr_soft_coding_keyflex scl
2441: ,pay_assignment_actions paa
2442: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2443: AND paa.assignment_action_id = p_assignment_action_id
2464: IS
2465: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
2466: FROM pay_assignment_actions paa
2467: ,pay_payroll_actions ppa
2468: ,per_assignments_f paf
2469: WHERE paf.assignment_id = paa.assignment_id
2470: AND paf.assignment_id = p_assignment_id
2471: AND paa.tax_unit_id = p_tax_unit_id
2472: AND paa.payroll_action_id = ppa.payroll_action_id