APPS.PAY_ELEMENT_LINKS_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 156: from pay_element_entries_f

152: p_validation_end_date date) is
153: --
154: cursor csr_links_entries is
155: select element_entry_id
156: from pay_element_entries_f
157: where element_link_id = p_element_link_id
158: and p_session_date between effective_start_date
159: and effective_end_date;
160: --

Line 1366: from pay_element_entries_f

1362: v_entries_exist boolean := FALSE;
1363: --
1364: cursor csr_entries is
1365: select 1
1366: from pay_element_entries_f
1367: where element_link_id = p_element_link_id;
1368: begin
1369: --
1370: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.ELEMENT_ENTRIES_EXIST', 1);

Line 1433: from pay_element_entries_f ENTRY1

1429: --
1430: -- Are there entries whose earliest start date is after the deletion date?
1431: cursor csr_entries is
1432: select 1
1433: from pay_element_entries_f ENTRY1
1434: where entry1.element_link_id = p_element_link_id
1435: and not(entry1.effective_start_date < p_validation_start_date);
1436: --
1437: -- Bug 1490304 - removed p_delete_mode from where clause.

Line 1441: from pay_element_entries_f BALANCE_ENTRY

1437: -- Bug 1490304 - removed p_delete_mode from where clause.
1438: --
1439: cursor csr_balance_adjustments is
1440: select 1
1441: from pay_element_entries_f BALANCE_ENTRY
1442: where balance_entry.element_link_id = p_element_link_id
1443: and balance_entry.effective_start_date > p_validation_start_date
1444: -- and p_delete_mode in ('DELETE','ZAP')
1445: and balance_entry.entry_type = 'B';