APPS.HRASSACT dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1369: delete from pay_element_entry_values_f EEV

1365: -- delete any element entry values
1366: if g_debug then
1367: hr_utility.set_location('hrassact.trash_quickpay',50);
1368: end if;
1369: delete from pay_element_entry_values_f EEV
1370: where EEV.element_entry_id = c1rec.element_entry_id;
1371: --
1372: -- delete the entry itself
1373: if g_debug then

Line 1571: delete from pay_element_entry_values_f eev

1567: --
1568: if g_debug then
1569: hr_utility.set_location(c_indent, 80);
1570: end if;
1571: delete from pay_element_entry_values_f eev
1572: where eev.element_entry_id = p_ee_id
1573: and ((eev.effective_end_date between val_start and val_end)
1574: or (eev.effective_start_date between val_start and val_end));
1575: --

Line 1580: update pay_element_entry_values_f eev

1576: -- Update the effective end date as appropriate.
1577: if g_debug then
1578: hr_utility.set_location(c_indent, 90);
1579: end if;
1580: update pay_element_entry_values_f eev
1581: set eev.effective_end_date = val_end
1582: where eev.element_entry_id = p_ee_id
1583: and p_date between
1584: eev.effective_start_date and eev.effective_end_date;

Line 1691: delete from pay_element_entry_values_f pev

1687: pee.effective_start_date and pee.effective_end_date;
1688: --
1689: -- Now, we attempt to delete the entry values.
1690: -- hr_utility.set_location('hrassact.do_assact_rollback',60);
1691: delete from pay_element_entry_values_f pev
1692: where pev.element_entry_id = v_eeid
1693: and p_pact_rec.action_date between
1694: pev.effective_start_date and pev.effective_end_date;
1695: --

Line 6003: pay_element_entry_values_f pev

5999: pay_run_results_s.currval,
6000: null
6001: from pay_payroll_actions pac,
6002: pay_assignment_actions act, -- reversal
6003: pay_element_entry_values_f pev
6004: where act.assignment_action_id = c1rec.assignment_action_id --rev
6005: and act.payroll_action_id = pac.payroll_action_id
6006: and pev.element_entry_id = c1rec.element_entry_id
6007: and pac.date_earned between