40: ,c_effective_date DATE) IS
41: SELECT pap.per_information5
42: ,pps.adjusted_svc_date
43: FROM per_all_people_f pap
44: ,per_all_assignments_f paaf
45: ,per_periods_of_service pps
46: WHERE paaf.assignment_id = c_assignment_id
47: AND paaf.person_id = pap.person_id
48: AND pap.person_id = pps.person_id
53: CURSOR csr_get_assign_info(c_assignment_id NUMBER
54: ,c_effective_date DATE) IS
55: SELECT segment5
56: ,segment2
57: FROM per_all_assignments_f paaf
58: ,hr_soft_coding_keyflex scl
59: WHERE paaf.assignment_id = c_assignment_id
60: AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
61: AND c_effective_date between paaf.effective_start_date and paaf.effective_end_date;
106: ,paa.abs_information3 ptm_perc
107: FROM per_absence_attendances paa
108: ,per_absence_attendance_types paat
109: ,per_all_people_f pap
110: ,per_all_assignments_f paaf
111: WHERE paaf.assignment_id = c_assignment_id
112: AND paaf.business_group_id = c_business_group_id
113: AND paaf.person_id = pap.person_id
114: AND pap.person_id = paa.person_id
202: ,time_end
203: FROM per_absence_attendances paa
204: ,per_absence_attendance_types paat
205: ,per_all_people_f pap
206: ,per_all_assignments_f paaf
207: WHERE paaf.assignment_id = c_assignment_id
208: AND paaf.business_group_id = c_business_group_id
209: AND paaf.person_id = pap.person_id
210: AND pap.person_id = paa.person_id
576: ,c_effective_date DATE) IS
577: SELECT sum(CTR_INFORMATION2) In_Class_trng_hours
578: ,sum(CTR_INFORMATION3) Remote_trng_hours
579: FROM PER_CONTRACTS_f pcf
580: ,per_all_assignments_f paaf
581: WHERE paaf.assignment_id = c_assignment_id
582: AND paaf.business_group_id = c_business_gr_id
583: AND paaf.contract_id = pcf.contract_id
584: AND pcf.ctr_information_category = 'ES'
651: ,ppa.action_type
652: ,MAX(paa2.assignment_action_id) assignment_action_id
653: FROM pay_assignment_actions paa1
654: ,pay_assignment_actions paa2
655: ,per_all_assignments_f paaf1
656: ,per_all_assignments_f paaf2
657: ,pay_payroll_actions ppa
658: ,pay_payroll_actions ppa1
659: ,per_time_periods ptp
652: ,MAX(paa2.assignment_action_id) assignment_action_id
653: FROM pay_assignment_actions paa1
654: ,pay_assignment_actions paa2
655: ,per_all_assignments_f paaf1
656: ,per_all_assignments_f paaf2
657: ,pay_payroll_actions ppa
658: ,pay_payroll_actions ppa1
659: ,per_time_periods ptp
660: ,per_time_period_types ptpt
685: ,ppa.action_type
686: ,MAX(paa2.assignment_action_id) assignment_action_id
687: FROM pay_assignment_actions paa1
688: ,pay_assignment_actions paa2
689: ,per_all_assignments_f paaf1
690: ,per_all_assignments_f paaf2
691: ,pay_payroll_actions ppa
692: ,per_time_periods ptp
693: WHERE paa1.assignment_action_id = c_assignment_action_id
686: ,MAX(paa2.assignment_action_id) assignment_action_id
687: FROM pay_assignment_actions paa1
688: ,pay_assignment_actions paa2
689: ,per_all_assignments_f paaf1
690: ,per_all_assignments_f paaf2
691: ,pay_payroll_actions ppa
692: ,per_time_periods ptp
693: WHERE paa1.assignment_action_id = c_assignment_action_id
694: AND paa1.assignment_id = paaf1.assignment_id
1243: CURSOR csr_get_assign_info(c_assignment_id NUMBER
1244: ,c_effective_date DATE) IS
1245: SELECT segment5
1246: ,segment2
1247: FROM per_all_assignments_f paaf
1248: ,hr_soft_coding_keyflex scl
1249: WHERE paaf.assignment_id = c_assignment_id
1250: AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1251: AND c_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1604: ,ptp.end_date end_date
1605: ,ppa.action_type
1606: ,max(paa2.assignment_action_id) assignment_action_id
1607: FROM pay_assignment_actions paa1
1608: ,per_all_assignments_f paaf1
1609: ,per_all_assignments_f paaf2
1610: ,pay_assignment_actions paa2
1611: ,pay_payroll_actions ppa
1612: ,pay_payroll_actions ppa1
1605: ,ppa.action_type
1606: ,max(paa2.assignment_action_id) assignment_action_id
1607: FROM pay_assignment_actions paa1
1608: ,per_all_assignments_f paaf1
1609: ,per_all_assignments_f paaf2
1610: ,pay_assignment_actions paa2
1611: ,pay_payroll_actions ppa
1612: ,pay_payroll_actions ppa1
1613: ,per_time_periods ptp
1638: ,ppa.action_type
1639: ,MAX(paa2.assignment_action_id) assignment_action_id
1640: FROM pay_assignment_actions paa1
1641: ,pay_assignment_actions paa2
1642: ,per_all_assignments_f paaf1
1643: ,per_all_assignments_f paaf2
1644: ,pay_payroll_actions ppa
1645: ,per_time_periods ptp
1646: WHERE paa1.assignment_action_id = c_assignment_action_id
1639: ,MAX(paa2.assignment_action_id) assignment_action_id
1640: FROM pay_assignment_actions paa1
1641: ,pay_assignment_actions paa2
1642: ,per_all_assignments_f paaf1
1643: ,per_all_assignments_f paaf2
1644: ,pay_payroll_actions ppa
1645: ,per_time_periods ptp
1646: WHERE paa1.assignment_action_id = c_assignment_action_id
1647: AND paa1.assignment_id = paaf1.assignment_id