DBA Data[Home] [Help]

APPS.PQP_CAR_MILEAGE_FUNCTIONS dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 461: FROM pqp_assignment_attributes_f pcv

457: ---curor.
458: CURSOR c_get_config_rt_temp
459: IS
460: SELECT pcv.aat_information5 rates_type
461: FROM pqp_assignment_attributes_f pcv
462: WHERE rownum=1;
463:
464: CURSOR c_get_attr_val_temp
465: IS

Line 473: ,pqp_assignment_attributes_f pva

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
477: IS

Line 479: FROM pqp_assignment_attributes_f pcv

475:
476: CURSOR c_get_config_info_temp
477: IS
478: SELECT pcv.aat_information1 calculation_method
479: FROM pqp_assignment_attributes_f pcv
480: WHERE rownum=1;
481:
482: /*CURSOR c_get_attr_val
483: IS

Line 556: FROM PQP_ASSIGNMENT_ATTRIBUTES_F

552: ,private_car_rates_table_id
553: ,private_car_essential_table_id
554: ,company_car_calc_method
555: ,private_car_calc_method
556: FROM PQP_ASSIGNMENT_ATTRIBUTES_F
557: WHERE assignment_id = p_assignment_id
558: AND decode(TO_CHAR(TRUNC(p_claim_date),'DD/MM/YYYY'),
559: '01/01/1900',l_effective_date,p_claim_date)
560: BETWEEN effective_start_date AND effective_end_date;