DBA Data[Home] [Help]

APPS.PER_IN_ENTRY_VALUE_LEG_HOOK dependencies on PAY_ELEMENT_ENTRIES_F

Line 238: ,pay_element_entries_f pee

234:
235: CURSOR c_other_loan_element(p_element_name VARCHAR2) IS
236: SELECT pee.element_entry_id
237: FROM pay_element_types_f pet
238: ,pay_element_entries_f pee
239: WHERE pet.element_type_id =pee.element_type_id
240: AND pee.assignment_id = p_assignment_id_o
241: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
242: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date