[Home] [Help]
3:
4: g_package CONSTANT VARCHAR2(20):= 'pay_gb_edi_p46_car.';
5:
6: -- Global Variables for Process Parameters
7: g_payroll_id pay_payrolls_f.payroll_id%TYPE;
8: g_start_date DATE;
9: g_end_date DATE;
10: g_business_group_id hr_organization_units.business_group_id%TYPE;
11: g_tax_ref VARCHAR2(20);
254: p_eff_date IN DATE) IS
255: SELECT flex.segment1 tax_ref
256: FROM hr_soft_coding_keyflex flex,
257: per_assignments_f asg,
258: Pay_payrolls_f ppf
259: WHERE asg.assignment_id = p_assignment_id
260: AND p_eff_date BETWEEN asg.effective_start_date AND asg.effective_end_date
261: AND asg.payroll_id = ppf.payroll_id
262: AND p_eff_date BETWEEN ppf.effective_start_Date and ppf.effective_end_date
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
854: AND asg.business_group_id = g_business_group_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
1319: AND asg.business_group_id = g_business_group_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
1853: AND asg.business_group_id = g_business_group_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
2393: AND asg.business_group_id = g_business_group_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
3365: AND asg.payroll_id +0 = nvl(g_payroll_id,asg.payroll_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
3801: AND asg.payroll_id +0 = nvl(g_payroll_id,asg.payroll_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
4300: AND asg.payroll_id +0 = nvl(g_payroll_id,asg.payroll_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
4806: AND asg.payroll_id +0 = nvl(g_payroll_id,asg.payroll_id)