DBA Data[Home] [Help]

APPS.PAY_ES_ADVANCE_PAY dependencies on PAY_ELEMENT_ENTRIES_F

Line 17: FROM pay_element_entries_f peef

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