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 1840: ,pqp_vehicle_allocations_f pva

1836: IS
1837: SELECT pvr.registration_number
1838: ,pva.default_vehicle
1839: FROM pqp_vehicle_repository_f pvr
1840: ,pqp_vehicle_allocations_f pva
1841: WHERE pva.vehicle_repository_id=pvr.vehicle_repository_id
1842: AND pvr.vehicle_ownership=p_ownership
1843: AND pva.usage_type=p_usage_type
1844: AND pva.assignment_id=p_assignment_id

Line 1871: FROM pqp_vehicle_allocations_f pva

1867:
1868: CURSOR c_chk_alloc (cp_registration_number VARCHAR2)
1869: IS
1870: SELECT 'Start_Valid' valid_date
1871: FROM pqp_vehicle_allocations_f pva
1872: ,per_all_assignments_f paa
1873: ,pqp_vehicle_repository_f pvr
1874: WHERE pva.assignment_id=p_assignment_id
1875: AND pvr.registration_number=cp_registration_number

Line 1889: FROM pqp_vehicle_allocations_f pva

1885: AND p_start_date BETWEEN pvr.effective_start_date
1886: AND pvr.effective_end_date
1887: UNION
1888: SELECT 'End_Valid' valid_date
1889: FROM pqp_vehicle_allocations_f pva
1890: ,per_all_assignments_f paa
1891: ,pqp_vehicle_repository_f pvr
1892: WHERE pva.assignment_id=p_assignment_id
1893: AND pvr.registration_number=cp_registration_number

Line 1998: ,pqp_vehicle_allocations_f pva

1994: ,pvr.fiscal_ratings
1995: ,pvr.engine_capacity_in_cc
1996: ,pvr.fuel_type
1997: FROM pqp_vehicle_repository_f pvr
1998: ,pqp_vehicle_allocations_f pva
1999: WHERE (pvr.registration_number =p_registration_number
2000: OR p_registration_number IS NULL)
2001: AND pva.assignment_id= p_assignment_id
2002: AND pvr.business_group_id = p_business_group_id

Line 2189: FROM pqp_vehicle_allocations_f pva,

2185: ,cp_start_date VARCHAR2
2186: )
2187: IS
2188: SELECT DISTINCT pvr.vehicle_ownership ownership
2189: FROM pqp_vehicle_allocations_f pva,
2190: pqp_vehicle_repository_f pvr
2191: WHERE pva.assignment_id =cp_assignment_id
2192: AND pva.business_group_id =cp_business_group_id
2193: AND pva.vehicle_repository_id=pvr.vehicle_repository_id