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_DETAILS

Line 472: pqp_vehicle_details pvd

468: --
469: CURSOR get_vin IS
470: SELECT pvd.vehicle_identification_number
471: FROM pqp_assignment_attributes_f paaf,
472: pqp_vehicle_details pvd
473: WHERE l_ben_start_date BETWEEN paaf.effective_start_date
474: AND paaf.effective_end_date
475: AND paaf.assignment_id = p_assignment_id -- comes from context
476: AND pvd.vehicle_details_id = paaf.primary_company_car;

Line 507: pqp_vehicle_details pvd

503: --
504: CURSOR get_make IS
505: SELECT pvd.make
506: FROM pqp_assignment_attributes_f paaf,
507: pqp_vehicle_details pvd
508: WHERE l_ben_start_date BETWEEN paaf.effective_start_date
509: AND paaf.effective_end_date
510: AND paaf.assignment_id = p_assignment_id -- comes from context
511: AND pvd.vehicle_details_id = paaf.primary_company_car;

Line 541: pqp_vehicle_details pvd

537: --
538: CURSOR get_model IS
539: SELECT pvd.model
540: FROM pqp_assignment_attributes_f paaf,
541: pqp_vehicle_details pvd
542: WHERE l_ben_start_date BETWEEN paaf.effective_start_date
543: AND paaf.effective_end_date
544: AND paaf.assignment_id = p_assignment_id -- comes from context
545: AND pvd.vehicle_details_id = paaf.primary_company_car;

Line 575: pqp_vehicle_details pvd

571: --
572: CURSOR get_dfr IS
573: SELECT pvd.date_first_registered
574: FROM pqp_assignment_attributes_f paaf,
575: pqp_vehicle_details pvd
576: WHERE l_ben_start_date BETWEEN paaf.effective_start_date
577: AND paaf.effective_end_date
578: AND paaf.assignment_id = p_assignment_id -- comes from context
579: AND pvd.vehicle_details_id = paaf.primary_company_car;

Line 609: pqp_vehicle_details pvd

605: --
606: CURSOR get_price IS
607: SELECT decode(nvl(pvd.market_value_classic_car,0), 0, list_price, pvd.market_value_classic_car)
608: FROM pqp_assignment_attributes_f paaf,
609: pqp_vehicle_details pvd
610: WHERE l_ben_start_date BETWEEN paaf.effective_start_date
611: AND paaf.effective_end_date
612: AND paaf.assignment_id = p_assignment_id -- comes from context
613: AND pvd.vehicle_details_id = paaf.primary_company_car;

Line 646: pqp_vehicle_details pvd,

642: --
643: CURSOR get_fuel_type IS
644: SELECT hl.description --pvd.fuel_type -- Bug 5017957
645: FROM pqp_assignment_attributes_f paaf,
646: pqp_vehicle_details pvd,
647: hr_lookups hl
648: WHERE l_ben_start_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
649: AND paaf.assignment_id = p_assignment_id -- comes from context
650: AND pvd.vehicle_details_id = paaf.primary_company_car

Line 698: pqp_vehicle_details pvd

694: --
695: CURSOR get_co2_emi IS
696: SELECT pvd.co2_emissions
697: FROM pqp_assignment_attributes_f paaf,
698: pqp_vehicle_details pvd
699: WHERE l_ben_start_date BETWEEN paaf.effective_start_date
700: AND paaf.effective_end_date
701: AND paaf.assignment_id = p_assignment_id -- comes from context
702: AND pvd.vehicle_details_id = paaf.primary_company_car;

Line 733: pqp_vehicle_details pvd

729: --
730: CURSOR get_opt_acc IS
731: SELECT decode(nvl(pvd.market_value_classic_car,0), 0, pvd.accessory_value_at_startdate, 0)
732: FROM pqp_assignment_attributes_f paaf,
733: pqp_vehicle_details pvd
734: WHERE l_ben_start_date BETWEEN paaf.effective_start_date
735: AND paaf.effective_end_date
736: AND paaf.assignment_id = p_assignment_id -- comes from context
737: AND pvd.vehicle_details_id = paaf.primary_company_car;

Line 767: pqp_vehicle_details pvd

763: --
764: CURSOR get_acc_added IS
765: SELECT pvd.accessory_value_added_later
766: FROM pqp_assignment_attributes_f paaf,
767: pqp_vehicle_details pvd
768: WHERE l_ben_start_date BETWEEN paaf.effective_start_date
769: AND paaf.effective_end_date
770: AND paaf.assignment_id = p_assignment_id -- comes from context
771: AND pvd.vehicle_details_id = paaf.primary_company_car;

Line 867: pqp_vehicle_details pvd

863: --
864: CURSOR get_engine_cap IS
865: SELECT pvd.engine_capacity_in_cc
866: FROM pqp_assignment_attributes_f paaf,
867: pqp_vehicle_details pvd
868: WHERE l_ben_start_date BETWEEN paaf.effective_start_date
869: AND paaf.effective_end_date
870: AND paaf.assignment_id = p_assignment_id -- comes from context
871: AND pvd.vehicle_details_id = paaf.primary_company_car;

Line 1161: FROM pqp_vehicle_details pvd,

1157: pvd.co2_emissions,
1158: decode(nvl(pvd.market_value_classic_car,0), 0, pvd.accessory_value_at_startdate, 0) optional_accessory,
1159: pvd.accessory_value_added_later,
1160: pvd.engine_capacity_in_cc
1161: FROM pqp_vehicle_details pvd,
1162: hr_lookups h1, -- Bug fix 3799560
1163: hr_lookups h2
1164: WHERE pvd.vehicle_details_id = p_vehicle_details_id
1165: AND pvd.fuel_type = h2.lookup_code