APPS.PAY_ELEMENT_LINKS_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 147: from pay_element_entries_f

143: p_validation_end_date date) is
144: --
145: cursor csr_links_entries is
146: select element_entry_id
147: from pay_element_entries_f
148: where element_link_id = p_element_link_id
149: and p_session_date between effective_start_date
150: and effective_end_date;
151: --

Line 1355: from pay_element_entries_f

1351: v_entries_exist boolean := FALSE;
1352: --
1353: cursor csr_entries is
1354: select 1
1355: from pay_element_entries_f
1356: where element_link_id = p_element_link_id;
1357: begin
1358: --
1359: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.ELEMENT_ENTRIES_EXIST', 1);

Line 1422: from pay_element_entries_f ENTRY1

1418: --
1419: -- Are there entries whose earliest start date is after the deletion date?
1420: cursor csr_entries is
1421: select 1
1422: from pay_element_entries_f ENTRY1
1423: where entry1.element_link_id = p_element_link_id
1424: and not(entry1.effective_start_date < p_validation_start_date);
1425: --
1426: -- Bug 1490304 - removed p_delete_mode from where clause.

Line 1430: from pay_element_entries_f BALANCE_ENTRY

1426: -- Bug 1490304 - removed p_delete_mode from where clause.
1427: --
1428: cursor csr_balance_adjustments is
1429: select 1
1430: from pay_element_entries_f BALANCE_ENTRY
1431: where balance_entry.element_link_id = p_element_link_id
1432: and balance_entry.effective_start_date > p_validation_start_date
1433: -- and p_delete_mode in ('DELETE','ZAP')
1434: and balance_entry.entry_type = 'B';