DBA Data[Home] [Help]

APPS.PQP_CAR_MILEAGE_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 2586: FROM pay_element_types_f petf

2582: ,cp_element_type_id NUMBER
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

Line 2647: ,pay_element_types_f pet

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
2651: AND petef.information_type='PQP_VEHICLE_MILEAGE_INFO'