DBA Data[Home] [Help]

APPS.PER_CAGR_EVALUATION_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 1002: l_element_entry_id pay_element_entries_f.element_entry_id%type;

998: -- This is used by all modes (but check_cache determines whether called by SE or BE).
999: --
1000:
1001: -- Bug 12621959
1002: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1003: l_effective_start_date date;
1004: l_effective_end_date date;
1005: l_delete_warning boolean;
1006: l_ovn number;

Line 1012: FROM pay_element_entries_f ee,per_cagr_entitlement_results cer

1008:
1009: -- Bug 14096456
1010: CURSOR csr_invalid_element_entries(p_assignment_id NUMBER, p_element_type_id NUMBER) IS
1011: SELECT ee.element_entry_id,ee.object_version_number
1012: FROM pay_element_entries_f ee,per_cagr_entitlement_results cer
1013: WHERE ee.assignment_id = p_assignment_id
1014: AND ee.assignment_id = cer.assignment_id
1015: AND ee.element_type_id = cer.element_type_id
1016: AND ee.effective_start_date = p_params.effective_date