[Home] [Help]
42: CURSOR c_first_asg (p_assignment_id IN NUMBER, p_eff_date IN DATE) IS
43: SELECT min(paaf.assignment_id) assignment_id
44: FROM pay_all_payrolls_f papf,
45: hr_soft_coding_keyflex sck,
46: per_all_assignments_f paaf,
47: per_all_assignments_f paaf2,
48: Pqp_vehicle_repository_f vr,
49: Pqp_vehicle_allocations_f va
50: WHERE paaf2.assignment_id = p_assignment_id
43: SELECT min(paaf.assignment_id) assignment_id
44: FROM pay_all_payrolls_f papf,
45: hr_soft_coding_keyflex sck,
46: per_all_assignments_f paaf,
47: per_all_assignments_f paaf2,
48: Pqp_vehicle_repository_f vr,
49: Pqp_vehicle_allocations_f va
50: WHERE paaf2.assignment_id = p_assignment_id
51: AND paaf2.person_id = paaf.person_id
845: asg.assignment_id,
846: min(asg.effective_start_date) asg_min_start_date,
847: max(asg.effective_end_date) asg_max_end_date
848: FROM hr_soft_coding_keyflex flex,
849: per_all_assignments_f asg,
850: pay_payrolls_f ppf,
851: pqp_vehicle_allocations_f va,
852: pqp_vehicle_repository_f vr
853: WHERE asg.person_id BETWEEN stperson AND endperson
1310: asg.assignment_id,
1311: min(asg.effective_start_date) asg_min_start_date,
1312: max(asg.effective_end_date) asg_max_end_date
1313: FROM hr_soft_coding_keyflex flex,
1314: per_all_assignments_f asg,
1315: pay_payrolls_f ppf,
1316: pqp_vehicle_allocations_f va,
1317: pqp_vehicle_repository_f vr
1318: WHERE asg.person_id BETWEEN stperson AND endperson
1844: asg.assignment_id,
1845: min(asg.effective_start_date) asg_min_start_date,
1846: max(asg.effective_end_date) asg_max_end_date
1847: FROM hr_soft_coding_keyflex flex,
1848: per_all_assignments_f asg,
1849: pay_payrolls_f ppf,
1850: pqp_vehicle_allocations_f va,
1851: pqp_vehicle_repository_f vr
1852: WHERE asg.person_id BETWEEN stperson AND endperson
2384: asg.assignment_id,
2385: min(asg.effective_start_date) asg_min_start_date,
2386: max(asg.effective_end_date) asg_max_end_date
2387: FROM hr_soft_coding_keyflex flex,
2388: per_all_assignments_f asg,
2389: pay_payrolls_f ppf,
2390: pqp_vehicle_allocations_f va,
2391: pqp_vehicle_repository_f vr
2392: WHERE asg.person_id BETWEEN stperson AND endperson
3356: SELECT asg.assignment_id,
3357: min(asg.effective_start_date) asg_min_start_date,
3358: max(asg.effective_end_date) asg_max_end_date
3359: FROM hr_soft_coding_keyflex flex,
3360: per_all_assignments_f asg,
3361: Pay_payrolls_f ppf,
3362: pay_assignment_actions act
3363: WHERE act.assignment_action_id = p_assactid
3364: AND act.assignment_id = asg.assignment_id
3792: SELECT asg.assignment_id,
3793: min(asg.effective_start_date) asg_min_start_date,
3794: max(asg.effective_end_date) asg_max_end_date
3795: FROM hr_soft_coding_keyflex flex,
3796: per_all_assignments_f asg,
3797: Pay_payrolls_f ppf,
3798: pay_assignment_actions act
3799: WHERE act.assignment_action_id = p_assactid
3800: AND act.assignment_id = asg.assignment_id
4291: SELECT asg.assignment_id,
4292: min(asg.effective_start_date) asg_min_start_date,
4293: max(asg.effective_end_date) asg_max_end_date
4294: FROM hr_soft_coding_keyflex flex,
4295: per_all_assignments_f asg,
4296: Pay_payrolls_f ppf,
4297: pay_assignment_actions act
4298: WHERE act.assignment_action_id = p_assactid
4299: AND act.assignment_id = asg.assignment_id
4797: SELECT asg.assignment_id,
4798: min(asg.effective_start_date) asg_min_start_date,
4799: max(asg.effective_end_date) asg_max_end_date
4800: FROM hr_soft_coding_keyflex flex,
4801: per_all_assignments_f asg,
4802: Pay_payrolls_f ppf,
4803: pay_assignment_actions act
4804: WHERE act.assignment_action_id = p_assactid
4805: AND act.assignment_id = asg.assignment_id