APPS.PQP_CAR_MILEAGE_FUNCTIONS dependencies on PQP_VEHICLE_DETAILS

Line 59: l_fuel_type pqp_vehicle_details.fuel_type%TYPE;

55: ---------------------------------------------------------------------------------
56: FUNCTION get_fuel_type (p_veh_id IN NUMBER)
57: RETURN CHAR
58: IS
59: l_fuel_type pqp_vehicle_details.fuel_type%TYPE;
60: l_fuel VARCHAR2(50);
61: BEGIN
62: SELECT fuel_type
63: INTO l_fuel_type

Line 64: FROM pqp_vehicle_details

60: l_fuel VARCHAR2(50);
61: BEGIN
62: SELECT fuel_type
63: INTO l_fuel_type
64: FROM pqp_vehicle_details
65: WHERE vehicle_details_id=p_veh_id;
66:
67: IF l_fuel_type='P' THEN
68: l_fuel:='Petrol';

Line 472: FROM pqp_vehicle_details pvr

468: ,pvr.engine_capacity_in_cc engine_capacity_in_cc
469: ,pvr.fuel_type fuel_type
470: ,pvr.vehicle_type default_vehicle
471: ,pvr.vehicle_type vehicle_type
472: FROM pqp_vehicle_details pvr
473: ,pqp_assignment_attributes_f pva
474: WHERE rownum=1;
475:
476: CURSOR c_get_config_info_temp

Line 542: FROM pqp_vehicle_details pvd

538:
539: CURSOR c_get_veh_typ (cp_vehicle_id NUMBER)
540: IS
541: SELECT pvd.vehicle_type
542: FROM pqp_vehicle_details pvd
543: WHERE pvd.vehicle_details_id =cp_vehicle_id
544: AND pvd.business_group_id=p_business_group_id;
545:
546: CURSOR ATTR_CUR IS

Line 625: l_vehicle_details_id PQP_VEHICLE_DETAILS.vehicle_details_id%TYPE;

621:
622: l_get_veh_typ c_get_veh_typ%ROWTYPE;
623: l_get_config_info c_get_config_info_temp%ROWTYPE;
624: l_get_attr_val c_get_attr_val_temp%ROWTYPE;
625: l_vehicle_details_id PQP_VEHICLE_DETAILS.vehicle_details_id%TYPE;
626: l_rates_table_id NUMBER(9);
627: l_exst VARCHAR2(1);
628: l_rates_table_name pay_user_tables.user_table_name%TYPE;
629: l_get_config_rates c_get_config_rt_temp%ROWTYPE;

Line 722: FROM PQP_VEHICLE_DETAILS

718:
719: IF l_vehicle_details_id IS NOT NULL THEN
720: SELECT engine_capacity_in_cc
721: INTO p_cc
722: FROM PQP_VEHICLE_DETAILS
723: WHERE vehicle_details_id = l_vehicle_details_id;
724: END IF;
725:
726: IF l_rates_table_id IS NOT NULL THEN

Line 1059: FROM pqp_vehicle_details

1055: RETURN NUMBER IS
1056:
1057: CURSOR veh_cur IS
1058: SELECT engine_capacity_in_cc
1059: FROM pqp_vehicle_details
1060: WHERE registration_number = p_reg_num;
1061:
1062: l_veh_cc NUMBER;
1063: