DBA Data[Home] [Help]

APPS.PAY_NO_ADVANCE_PAY dependencies on PAY_ELEMENT_ENTRIES_F

Line 20: FROM pay_element_entries_f peef

16: WHERE payroll_action_id = p_payroll_action_id;
17: --
18: CURSOR csr_creator_type(p_effective_date DATE) IS
19: SELECT creator_type
20: FROM pay_element_entries_f peef
21: WHERE peef.element_entry_id = p_element_entry_id
22: AND p_effective_date BETWEEN peef.effective_start_date
23: AND peef.effective_end_date;
24: --