2583: ,cp_effective_date DATE )
2584: IS
2585: SELECT pete.eei_information1 vehicle_type
2586: FROM pay_element_types_f petf
2587: ,pay_element_type_extra_info pete
2588: WHERE pete.information_type='PQP_VEHICLE_MILEAGE_INFO'
2589: AND pete.element_type_id=petf.element_type_id
2590: AND petf.element_type_id= cp_element_type_id
2591: AND petf.business_group_id= cp_business_group_id
2642: ,cp_eff_dt DATE
2643: )
2644: IS
2645: SELECT 'Y'
2646: FROM pay_element_type_extra_info petef
2647: ,pay_element_types_f pet
2648: ,pay_element_entries_f pee
2649: ,pay_element_entry_values_f pev
2650: WHERE pet.element_type_id =petef.element_type_id