DBA Data[Home] [Help]

APPS.PAY_US_BEE dependencies on PAY_ELEMENT_ENTRIES_F

Line 20: FROM pay_element_entries_f pee

16: CURSOR csr_base_entry_exists (p_element_link_id number,
17: p_assignment_id number,
18: p_effective_date date) IS
19: SELECT 'Y'
20: FROM pay_element_entries_f pee
21: WHERE pee.element_link_id = p_element_link_id
22: AND pee.assignment_id = p_assignment_id
23: AND p_effective_date between pee.effective_start_date
24: and pee.effective_end_date;