DBA Data[Home] [Help]

APPS.PQP_CAR_MILEAGE_FUNCTIONS dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 2587: ,pay_element_type_extra_info pete

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

Line 2646: FROM pay_element_type_extra_info petef

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