eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PQP_VEHICLE_ALLOCATIONS_F

Line 386: FROM pqp_vehicle_allocations_f pvaf,

382: IS
383: SELECT pvaf.element_type_id
384: ,pvaf.rates_table_id
385: ,pvaf.sliding_rates_info sliding_rates
386: FROM pqp_vehicle_allocations_f pvaf,
387: pqp_vehicle_repository_f pvrf
388: WHERE pvaf.assignment_id=cp_assignment_id
389: AND pvaf.business_group_id=cp_business_group_id
390: AND pvrf.vehicle_ownership=cp_ownership_type

Line 1826: ,pqp_vehicle_allocations_f pva

1822: IS
1823: SELECT pvr.registration_number
1824: ,pva.default_vehicle
1825: FROM pqp_vehicle_repository_f pvr
1826: ,pqp_vehicle_allocations_f pva
1827: WHERE pva.vehicle_repository_id=pvr.vehicle_repository_id
1828: AND pvr.vehicle_ownership=p_ownership
1829: AND pva.usage_type=p_usage_type
1830: AND pva.assignment_id=p_assignment_id

Line 1857: FROM pqp_vehicle_allocations_f pva

1853:
1854: CURSOR c_chk_alloc (cp_registration_number VARCHAR2)
1855: IS
1856: SELECT 'Start_Valid' valid_date
1857: FROM pqp_vehicle_allocations_f pva
1858: ,per_all_assignments_f paa
1859: ,pqp_vehicle_repository_f pvr
1860: WHERE pva.assignment_id=p_assignment_id
1861: AND pvr.registration_number=cp_registration_number

Line 1875: FROM pqp_vehicle_allocations_f pva

1871: AND p_start_date BETWEEN pvr.effective_start_date
1872: AND pvr.effective_end_date
1873: UNION
1874: SELECT 'End_Valid' valid_date
1875: FROM pqp_vehicle_allocations_f pva
1876: ,per_all_assignments_f paa
1877: ,pqp_vehicle_repository_f pvr
1878: WHERE pva.assignment_id=p_assignment_id
1879: AND pvr.registration_number=cp_registration_number

Line 1984: ,pqp_vehicle_allocations_f pva

1980: ,pvr.fiscal_ratings
1981: ,pvr.engine_capacity_in_cc
1982: ,pvr.fuel_type
1983: FROM pqp_vehicle_repository_f pvr
1984: ,pqp_vehicle_allocations_f pva
1985: WHERE (pvr.registration_number =p_registration_number
1986: OR p_registration_number IS NULL)
1987: AND pva.assignment_id= p_assignment_id
1988: AND pvr.business_group_id = p_business_group_id

Line 2175: FROM pqp_vehicle_allocations_f pva,

2171: ,cp_start_date VARCHAR2
2172: )
2173: IS
2174: SELECT DISTINCT pvr.vehicle_ownership ownership
2175: FROM pqp_vehicle_allocations_f pva,
2176: pqp_vehicle_repository_f pvr
2177: WHERE pva.assignment_id =cp_assignment_id
2178: AND pva.business_group_id =cp_business_group_id
2179: AND pva.vehicle_repository_id=pvr.vehicle_repository_id