APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PQP_VEHICLE_ALLOCATIONS_F

Line 1418: FROM pqp_vehicle_allocations_f paaf,

1414: --
1415: CURSOR get_veh_id IS
1416: SELECT greatest(min(paaf.effective_start_date), l_ext_start_date) effective_start_date,
1417: least(max(paaf.effective_end_date), l_ext_end_date) effective_end_date
1418: FROM pqp_vehicle_allocations_f paaf,
1419: pqp_vehicle_repository_f pvd
1420: WHERE paaf.assignment_id = p_asg_id
1421: AND paaf.effective_start_date <= l_ext_end_date
1422: AND paaf.effective_end_date >= l_ext_start_date

Line 1486: FROM pqp_vehicle_allocations_f paaf,

1482: --
1483: CURSOR get_veh_id IS
1484: SELECT greatest(min(paaf.effective_start_date), l_ext_start_date) effective_start_date,
1485: least(max(paaf.effective_end_date), l_ext_end_date) effective_end_date
1486: FROM pqp_vehicle_allocations_f paaf,
1487: pqp_vehicle_repository_f pvd
1488: WHERE paaf.assignment_id = p_asg_id
1489: AND paaf.effective_start_date <= l_ext_end_date
1490: AND paaf.effective_end_date >= l_ext_start_date

Line 1555: FROM pqp_vehicle_allocations_f paaf,

1551: --
1552: CURSOR get_veh_id IS
1553: SELECT greatest(min(paaf.effective_start_date), l_ext_start_date) effective_start_date,
1554: least(max(paaf.effective_end_date), l_ext_end_date) effective_end_date
1555: FROM pqp_vehicle_allocations_f paaf,
1556: pqp_vehicle_repository_f pvd
1557: WHERE paaf.assignment_id = p_asg_id
1558: AND paaf.effective_start_date <= l_ext_end_date
1559: AND paaf.effective_end_date >= l_ext_start_date

Line 1947: FROM pqp_vehicle_allocations_f paaf,

1943: ,p_rule_parameter in varchar2) return varchar2 is
1944:
1945: CURSOR check_veh_exists(c_ext_start_date date, c_ext_end_date date) IS
1946: SELECT 1
1947: FROM pqp_vehicle_allocations_f paaf,
1948: pqp_vehicle_repository_f pvd
1949: WHERE paaf.assignment_id = p_assignment_id
1950: AND paaf.effective_start_date <= c_ext_end_date
1951: AND paaf.effective_end_date >= c_ext_start_date