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.PAY_GB_P11D_CAR_EXTRACT dependencies on PQP_VEHICLE_ALLOCATIONS_F

Line 1019: FROM pqp_vehicle_allocations_f paaf,

1015: AND (paa.primary_company_car IS NOT NULL OR paa.secondary_company_car IS NOT NULL)
1016: AND l_ext_start_date < fnd_date.canonical_to_date('2003/04/06') -- BUG 3431106 Using canonical_to_date function
1017: UNION
1018: SELECT 'Y' vehicle_exist_flag
1019: FROM pqp_vehicle_allocations_f paaf,
1020: pqp_vehicle_repository_f pvd
1021: WHERE paaf.assignment_id = p_asg_id
1022: AND paaf.effective_start_date <= l_ext_end_date
1023: AND paaf.effective_end_date >= l_ext_start_date

Line 1677: FROM pqp_vehicle_allocations_f paaf,

1673: l_ext_end_date DATE := NULL;
1674: --
1675: CURSOR get_eff_start_date IS
1676: SELECT greatest(paaf.effective_start_date, l_ext_start_date) effective_start_date
1677: FROM pqp_vehicle_allocations_f paaf,
1678: pqp_vehicle_repository_f pvd
1679: WHERE paaf.assignment_id = p_assignment_id
1680: AND paaf.effective_start_date <= l_ext_end_date
1681: AND paaf.effective_end_date >= l_ext_start_date

Line 1721: FROM pqp_vehicle_allocations_f paaf,

1717: l_ben_start_date DATE := NULL;
1718: --
1719: CURSOR get_ben_details IS
1720: SELECT paaf.effective_end_date effective_end_date
1721: FROM pqp_vehicle_allocations_f paaf,
1722: pqp_vehicle_repository_f pvd
1723: WHERE paaf.assignment_id = p_assignment_id
1724: AND paaf.effective_start_date <= l_ext_end_date
1725: AND paaf.effective_end_date >= l_ext_start_date

Line 1767: FROM pqp_vehicle_allocations_f paaf,

1763: l_ext_start_date DATE := NULL;
1764: --
1765: CURSOR get_vin IS
1766: SELECT pvd.registration_number
1767: FROM pqp_vehicle_allocations_f paaf,
1768: pqp_vehicle_repository_f pvd
1769: WHERE paaf.assignment_id = p_assignment_id -- comes from context
1770: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id
1771: AND pvd.vehicle_type = 'C'

Line 1810: FROM pqp_vehicle_allocations_f paaf,

1806: l_ext_start_date DATE := NULL;
1807: --
1808: CURSOR get_make IS
1809: SELECT pvd.make
1810: FROM pqp_vehicle_allocations_f paaf,
1811: pqp_vehicle_repository_f pvd
1812: WHERE paaf.assignment_id = p_assignment_id -- comes from context
1813: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id
1814: AND pvd.vehicle_type = 'C'

Line 1852: FROM pqp_vehicle_allocations_f paaf,

1848: l_ext_start_date DATE := NULL;
1849: --
1850: CURSOR get_model IS
1851: SELECT pvd.model
1852: FROM pqp_vehicle_allocations_f paaf,
1853: pqp_vehicle_repository_f pvd
1854: WHERE paaf.assignment_id = p_assignment_id -- comes from context
1855: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id
1856: AND pvd.vehicle_type = 'C'

Line 1894: FROM pqp_vehicle_allocations_f paaf,

1890: l_ext_start_date DATE := NULL;
1891: --
1892: CURSOR get_dfr IS
1893: SELECT pvd.initial_registration
1894: FROM pqp_vehicle_allocations_f paaf,
1895: pqp_vehicle_repository_f pvd
1896: WHERE paaf.assignment_id = p_assignment_id -- comes from context
1897: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id
1898: AND pvd.vehicle_type = 'C'

Line 1936: FROM pqp_vehicle_allocations_f paaf,

1932: l_ext_start_date DATE := NULL;
1933: --
1934: CURSOR get_price IS
1935: SELECT decode(nvl(pvd.market_value_classic_car,0), 0, list_price, pvd.market_value_classic_car)+ nvl(pvd.accessory_value_at_startdate,0)
1936: FROM pqp_vehicle_allocations_f paaf,
1937: pqp_vehicle_repository_f pvd
1938: WHERE paaf.assignment_id = p_assignment_id -- comes from context
1939: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id
1940: AND pvd.vehicle_type = 'C'

Line 1981: FROM pqp_vehicle_allocations_f paaf,

1977: l_ext_start_date DATE := NULL;
1978: --
1979: CURSOR get_fuel_type IS
1980: SELECT hl.description -- pvd.fuel_type
1981: FROM pqp_vehicle_allocations_f paaf,
1982: pqp_vehicle_repository_f pvd,
1983: hr_lookups hl
1984: WHERE paaf.assignment_id = p_assignment_id -- comes from context
1985: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id

Line 2042: FROM pqp_vehicle_allocations_f paaf,

2038: l_ext_start_date DATE := NULL;
2039: --
2040: CURSOR get_co2_emi IS
2041: SELECT pvd.fiscal_ratings
2042: FROM pqp_vehicle_allocations_f paaf,
2043: pqp_vehicle_repository_f pvd
2044: WHERE paaf.assignment_id = p_assignment_id -- comes from context
2045: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id
2046: AND pvd.vehicle_type = 'C'

Line 2088: FROM pqp_vehicle_allocations_f paaf,

2084: --bug 7306948 begin
2085: --old line SELECT decode(nvl(pvd.market_value_classic_car,0), 0, pvd.accessory_value_at_startdate, 0)
2086: SELECT decode(nvl(pvd.market_value_classic_car,0), 0, pvd.accessory_value_added_later, 0)
2087: --bug 7306948 end
2088: FROM pqp_vehicle_allocations_f paaf,
2089: pqp_vehicle_repository_f pvd
2090: WHERE paaf.assignment_id = p_assignment_id -- comes from context
2091: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id
2092: AND pvd.vehicle_type = 'C'

Line 2130: FROM pqp_vehicle_allocations_f paaf,

2126: l_ext_start_date DATE := NULL;
2127: --
2128: CURSOR get_cap_contrib IS
2129: SELECT paaf.capital_contribution
2130: FROM pqp_vehicle_allocations_f paaf,
2131: pqp_vehicle_repository_f pvd
2132: WHERE paaf.assignment_id = p_assignment_id -- comes from context
2133: AND paaf.usage_type = 'P'
2134: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id

Line 2173: FROM pqp_vehicle_allocations_f paaf,

2169: l_ext_start_date DATE := NULL;
2170: --
2171: CURSOR get_pri_contrib IS
2172: SELECT paaf.private_contribution
2173: FROM pqp_vehicle_allocations_f paaf,
2174: pqp_vehicle_repository_f pvd
2175: WHERE paaf.assignment_id = p_assignment_id -- comes from context
2176: AND paaf.usage_type = 'P'
2177: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id

Line 2215: FROM pqp_vehicle_allocations_f paaf,

2211: l_ext_start_date DATE := NULL;
2212: --
2213: CURSOR get_engine_cap IS
2214: SELECT pvd.engine_capacity_in_cc
2215: FROM pqp_vehicle_allocations_f paaf,
2216: pqp_vehicle_repository_f pvd
2217: WHERE paaf.assignment_id = p_assignment_id -- comes from context
2218: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id
2219: AND pvd.vehicle_type = 'C'

Line 2257: FROM pqp_vehicle_allocations_f paaf,

2253: l_ext_start_date DATE := NULL;
2254: --
2255: CURSOR get_fuel_benefit IS
2256: SELECT substr(paaf.fuel_benefit, 1, 1)
2257: FROM pqp_vehicle_allocations_f paaf,
2258: pqp_vehicle_repository_f pvd
2259: WHERE paaf.assignment_id = p_assignment_id -- comes from context
2260: AND paaf.usage_type = 'P'
2261: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id

Line 2298: FROM pqp_vehicle_allocations_f paaf,

2294: l_ben_start_date DATE := NULL;
2295: --
2296: CURSOR get_fuel_reinstated IS
2297: SELECT substr(paaf.fuel_benefit,1,1) fuel_benefit
2298: FROM pqp_vehicle_allocations_f paaf,
2299: pqp_vehicle_repository_f pvd
2300: WHERE paaf.assignment_id = p_assignment_id -- comes from context
2301: AND paaf.usage_type = 'P'
2302: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id

Line 2350: FROM pqp_vehicle_allocations_f paaf,

2346: l_ext_start_date DATE := NULL;
2347: --
2348: CURSOR get_date_free_fuel_withdrawn IS
2349: SELECT substr(paaf.fuel_benefit,1,1)fuel_benefit,paaf.effective_end_date effective_end_date
2350: FROM pqp_vehicle_allocations_f paaf,
2351: pqp_vehicle_repository_f pvd
2352: WHERE paaf.assignment_id = p_assignment_id -- comes from context
2353: AND paaf.usage_type = 'P'
2354: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id

Line 2404: FROM pqp_vehicle_allocations_f paaf,

2400: l_flag VARCHAR2(30) := 'T';
2401: --
2402: CURSOR get_date_free_fuel IS
2403: SELECT paaf.fuel_benefit
2404: FROM pqp_vehicle_allocations_f paaf,
2405: pqp_vehicle_repository_f pvd
2406: WHERE paaf.assignment_id = p_assignment_id -- comes from context
2407: AND paaf.usage_type = 'P'
2408: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id

Line 2460: FROM pqp_vehicle_allocations_f paaf,

2456: l_ben_start_date DATE := NULL;
2457: --
2458: CURSOR get_fuel_reinstated IS
2459: SELECT substr(paaf.fuel_benefit,1,1) fuel_benefit
2460: FROM pqp_vehicle_allocations_f paaf,
2461: pqp_vehicle_repository_f pvd
2462: WHERE paaf.assignment_id = p_assignment_id -- comes from context
2463: AND paaf.usage_type = 'P'
2464: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id

Line 2514: FROM pqp_vehicle_allocations_f paaf,

2510: l_ext_start_date DATE := NULL;
2511: --
2512: CURSOR get_date_free_fuel_withdrawn IS
2513: SELECT substr(paaf.fuel_benefit,1,1)fuel_benefit,paaf.effective_end_date effective_end_date
2514: FROM pqp_vehicle_allocations_f paaf,
2515: pqp_vehicle_repository_f pvd
2516: WHERE paaf.assignment_id = p_assignment_id -- comes from context
2517: AND paaf.usage_type = 'P'
2518: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id

Line 2570: FROM pqp_vehicle_allocations_f paaf,

2566: l_flag VARCHAR2(30) := 'T';
2567: --
2568: CURSOR get_date_free_fuel IS
2569: SELECT paaf.fuel_benefit
2570: FROM pqp_vehicle_allocations_f paaf,
2571: pqp_vehicle_repository_f pvd
2572: WHERE paaf.assignment_id = p_assignment_id -- comes from context
2573: AND paaf.usage_type = 'P'
2574: AND pvd.vehicle_repository_id = paaf.vehicle_repository_id

Line 2661: FROM pqp_vehicle_allocations_f

2657: order by effective_end_date desc;
2658: --
2659: CURSOR check_fuel_benefit IS
2660: SELECT substr(fuel_benefit,1,1)fuel_benefit
2661: FROM pqp_vehicle_allocations_f
2662: WHERE assignment_id = p_asg_id
2663: AND effective_start_date <= p_benefit_end_date
2664: AND effective_end_date >= p_benefit_start_date;
2665:

Line 2670: FROM pqp_vehicle_allocations_f

2666: CURSOR get_asg_attributes IS
2667: SELECT capital_contribution,
2668: private_contribution,
2669: substr(fuel_benefit,1,1)fuel_benefit
2670: FROM pqp_vehicle_allocations_f
2671: WHERE assignment_id = p_asg_id
2672: AND effective_start_date <= p_benefit_end_date
2673: AND effective_end_date >= p_benefit_start_date
2674: order by effective_end_date desc;

Line 2812: FROM pqp_vehicle_allocations_f paaf,

2808: CURSOR get_veh_id IS
2809: SELECT greatest(paaf.effective_start_date, l_ext_start_date) effective_start_date,
2810: least(paaf.effective_end_date, l_ext_end_date) effective_end_date,
2811: paaf.fuel_benefit fuel_benefit,paaf.vehicle_repository_id vehicle_repository_id,paaf.vehicle_allocation_id vehicle_allocation_id
2812: FROM pqp_vehicle_allocations_f paaf,
2813: pqp_vehicle_repository_f pvd
2814: WHERE paaf.assignment_id = p_asg_id
2815: AND paaf.effective_start_date <= l_ext_end_date
2816: AND paaf.effective_end_date >= l_ext_start_date

Line 2837: FROM pqp_vehicle_allocations_f pvaf

2833: This will make the primary terminated assignments to be reported.
2834: */
2835: CURSOR get_sec_asg_and_shared IS
2836: SELECT 'Y' flag
2837: FROM pqp_vehicle_allocations_f pvaf
2838: WHERE pvaf.assignment_id = p_asg_id
2839: AND pvaf.across_assignments = 'Y'
2840: AND pvaf.usage_type = 'S'
2841: AND not exists (

Line 2955: FROM pqp_vehicle_allocations_f paaf,

2951: CURSOR get_veh_id IS
2952: SELECT greatest(paaf.effective_start_date, l_ext_start_date) effective_start_date,
2953: least(paaf.effective_end_date, l_ext_end_date) effective_end_date,
2954: paaf.fuel_benefit fuel_benefit,paaf.vehicle_repository_id vehicle_repository_id, paaf.vehicle_allocation_id vehicle_allocation_id
2955: FROM pqp_vehicle_allocations_f paaf,
2956: pqp_vehicle_repository_f pvd
2957: WHERE paaf.assignment_id = p_asg_id
2958: AND paaf.effective_start_date <= l_ext_end_date
2959: AND paaf.effective_end_date >= l_ext_start_date

Line 2979: FROM pqp_vehicle_allocations_f pvaf

2975: This will make the primary terminated assignments to be reported.
2976: */
2977: CURSOR get_sec_asg_and_shared IS
2978: SELECT 'Y' flag
2979: FROM pqp_vehicle_allocations_f pvaf
2980: WHERE pvaf.assignment_id = p_asg_id
2981: AND pvaf.across_assignments = 'Y'
2982: AND pvaf.usage_type = 'P'
2983: AND not exists (