DBA Data[Home] [Help]

APPS.PQP_CAR_MILEAGE_FUNCTIONS dependencies on PAY_ELEMENT_ENTRIES_F

Line 2472: FROM pay_element_entries_f pee

2468:
2469: CURSOR c_get_end_date (cp_date DATE)
2470: IS
2471: SELECT pee.effective_end_date
2472: FROM pay_element_entries_f pee
2473: WHERE pee.element_entry_id =p_element_entry_id
2474: AND pee.assignment_id =p_assignment_id
2475: AND pee.effective_end_date <=cp_date;
2476: l_get_payroll_date c_get_payroll_date%ROWTYPE;

Line 2648: ,pay_element_entries_f pee

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'
2652: AND petef.eei_information1 = 'P'