DBA Data[Home] [Help]

APPS.PAY_KW_PIFSS_REPORT dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 438: pay_element_entry_values_f pev

434: CURSOR csr_get_install_number (l_assignment_id number , l_type_id number, l_start_date date) IS
435: select pev.screen_entry_value
436: from pay_element_types_f pet,
437: pay_element_entries_f pee,
438: pay_element_entry_values_f pev
439: where pet.element_type_id = l_type_id
440: AND trunc(pet.effective_start_date,'MM') = trunc(l_start_date,'MM')
441: AND pee.element_type_id = pet.element_type_id
442: AND pee.assignment_id = l_assignment_id