DBA Data[Home] [Help]

APPS.PAY_CA_BEE dependencies on PAY_ELEMENT_ENTRIES_F

Line 52: FROM pay_element_entries_f pee

48:
49: CURSOR csr_base_entry_exists (p_element_link_id number, p_assignment_id number,
50: p_effective_date date) IS
51: SELECT 'Y'
52: FROM pay_element_entries_f pee
53: WHERE pee.element_link_id = p_element_link_id
54: AND pee.assignment_id = p_assignment_id
55: AND p_effective_date between pee.effective_start_date
56: and pee.effective_end_date;