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_ASSIGNMENT_ATTRIBUTES_F

Line 367: FROM pqp_assignment_attributes_f

363: l_ext_end_date DATE := NULL;
364: --
365: CURSOR get_eff_start_date IS
366: SELECT greatest(effective_start_date, l_ext_start_date) effective_start_date
367: FROM pqp_assignment_attributes_f
368: WHERE assignment_id = p_assignment_id
369: AND effective_start_date <= l_ext_end_date
370: AND effective_end_date >= l_ext_start_date
371: AND primary_company_car is NOT NULL

Line 405: FROM pqp_assignment_attributes_f

401: --
402: CURSOR get_ben_details IS
403: SELECT effective_start_date, effective_end_date,
404: primary_car_fuel_benefit, primary_company_car
405: FROM pqp_assignment_attributes_f
406: WHERE assignment_id = p_assignment_id
407: AND effective_start_date <= l_ext_end_date
408: AND effective_end_date >= l_ext_start_date
409: AND primary_company_car is NOT NULL

Line 471: FROM pqp_assignment_attributes_f paaf,

467: l_ben_start_date DATE := NULL;
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

Line 506: FROM pqp_assignment_attributes_f paaf,

502: l_ben_start_date DATE := NULL;
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

Line 540: FROM pqp_assignment_attributes_f paaf,

536: l_ben_start_date DATE := NULL;
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

Line 574: FROM pqp_assignment_attributes_f paaf,

570: l_ben_start_date DATE := NULL;
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

Line 608: FROM pqp_assignment_attributes_f paaf,

604: l_ben_start_date DATE := NULL;
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

Line 645: FROM pqp_assignment_attributes_f paaf,

641: l_ben_start_date DATE := NULL;
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

Line 697: FROM pqp_assignment_attributes_f paaf,

693: l_ben_start_date DATE := NULL;
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

Line 732: FROM pqp_assignment_attributes_f paaf,

728: l_ben_start_date DATE := NULL;
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

Line 766: FROM pqp_assignment_attributes_f paaf,

762: l_ben_start_date DATE := NULL;
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

Line 800: FROM pqp_assignment_attributes_f

796: l_ben_start_date DATE := NULL;
797: --
798: CURSOR get_cap_contrib IS
799: SELECT primary_capital_contribution
800: FROM pqp_assignment_attributes_f
801: WHERE l_ben_start_date BETWEEN effective_start_date
802: AND effective_end_date
803: AND assignment_id = p_assignment_id; -- comes from context
804: --

Line 833: FROM pqp_assignment_attributes_f

829: l_ben_start_date DATE := NULL;
830: --
831: CURSOR get_pri_contrib IS
832: SELECT primary_private_contribution
833: FROM pqp_assignment_attributes_f
834: WHERE l_ben_start_date BETWEEN effective_start_date
835: AND effective_end_date
836: AND assignment_id = p_assignment_id; -- comes from context
837: --

Line 866: FROM pqp_assignment_attributes_f paaf,

862: l_ben_start_date DATE := NULL;
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

Line 901: FROM pqp_assignment_attributes_f

897: l_ben_start_date DATE := NULL;
898: --
899: CURSOR get_fuel_benefit IS
900: SELECT substr(primary_car_fuel_benefit, 1, 1)
901: FROM pqp_assignment_attributes_f
902: WHERE l_ben_start_date BETWEEN effective_start_date
903: AND effective_end_date
904: AND assignment_id = p_assignment_id; -- comes from context
905: --

Line 934: FROM pqp_assignment_attributes_f

930: l_ben_start_date DATE := NULL;
931: --
932: CURSOR get_vehicle_details_id IS
933: SELECT primary_company_car
934: FROM pqp_assignment_attributes_f
935: WHERE l_ben_start_date BETWEEN effective_start_date
936: AND effective_end_date
937: AND assignment_id = p_assignment_id; -- comes from context
938: --

Line 1011: FROM pqp_assignment_attributes_f paa

1007: AND NVL (has.payroll_id, paaf.payroll_id) = paaf.payroll_id;
1008: --
1009: CURSOR check_vehicle_details(p_asg_id IN NUMBER) IS
1010: SELECT 'Y' vehicle_exist_flag
1011: FROM pqp_assignment_attributes_f paa
1012: WHERE paa.assignment_id = p_asg_id
1013: AND paa.effective_start_date <= l_ext_end_date
1014: AND paa.effective_end_date >= l_ext_start_date
1015: AND (paa.primary_company_car IS NOT NULL OR paa.secondary_company_car IS NOT NULL)

Line 1177: FROM pqp_assignment_attributes_f

1173: --
1174: CURSOR get_asg_attributes IS
1175: SELECT primary_capital_contribution,
1176: primary_private_contribution
1177: FROM pqp_assignment_attributes_f
1178: WHERE assignment_id = p_asg_id
1179: AND p_benefit_start_date BETWEEN effective_start_date AND effective_end_date;
1180: --
1181: l_vehicle_rec get_vehicle_details%ROWTYPE;

Line 1293: FROM pqp_assignment_attributes_f

1289: CURSOR get_veh_id IS
1290: SELECT greatest(effective_start_date, l_ext_start_date) effective_start_date,
1291: least(effective_end_date, l_ext_end_date) effective_end_date,
1292: primary_car_fuel_benefit, primary_company_car
1293: FROM pqp_assignment_attributes_f
1294: WHERE assignment_id = p_asg_id
1295: AND effective_start_date <= l_ext_end_date
1296: AND effective_end_date >= l_ext_start_date
1297: AND primary_company_car is NOT NULL

Line 1392: FROM pqp_assignment_attributes_f

1388: CURSOR get_veh_id IS
1389: SELECT greatest(effective_start_date, l_ext_start_date) effective_start_date,
1390: least(effective_end_date, l_ext_end_date) effective_end_date,
1391: secondary_car_fuel_benefit, secondary_company_car
1392: FROM pqp_assignment_attributes_f
1393: WHERE assignment_id = p_asg_id
1394: AND effective_start_date <= l_ext_end_date
1395: AND effective_end_date >= l_ext_start_date
1396: AND secondary_company_car is NOT NULL