APPS.HRASSACT dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1337: delete from pay_element_entry_values_f EEV

1333: -- delete any element entry values
1334: if g_debug then
1335: hr_utility.set_location('hrassact.trash_quickpay',50);
1336: end if;
1337: delete from pay_element_entry_values_f EEV
1338: where EEV.element_entry_id = c1rec.element_entry_id;
1339: --
1340: -- delete the entry itself
1341: if g_debug then

Line 1539: delete from pay_element_entry_values_f eev

1535: --
1536: if g_debug then
1537: hr_utility.set_location(c_indent, 80);
1538: end if;
1539: delete from pay_element_entry_values_f eev
1540: where eev.element_entry_id = p_ee_id
1541: and ((eev.effective_end_date between val_start and val_end)
1542: or (eev.effective_start_date between val_start and val_end));
1543: --

Line 1548: update pay_element_entry_values_f eev

1544: -- Update the effective end date as appropriate.
1545: if g_debug then
1546: hr_utility.set_location(c_indent, 90);
1547: end if;
1548: update pay_element_entry_values_f eev
1549: set eev.effective_end_date = val_end
1550: where eev.element_entry_id = p_ee_id
1551: and p_date between
1552: eev.effective_start_date and eev.effective_end_date;

Line 1659: delete from pay_element_entry_values_f pev

1655: pee.effective_start_date and pee.effective_end_date;
1656: --
1657: -- Now, we attempt to delete the entry values.
1658: -- hr_utility.set_location('hrassact.do_assact_rollback',60);
1659: delete from pay_element_entry_values_f pev
1660: where pev.element_entry_id = v_eeid
1661: and p_pact_rec.action_date between
1662: pev.effective_start_date and pev.effective_end_date;
1663: --

Line 5739: pay_element_entry_values_f pev

5735: pay_run_results_s.currval,
5736: null
5737: from pay_payroll_actions pac,
5738: pay_assignment_actions act, -- reversal
5739: pay_element_entry_values_f pev
5740: where act.assignment_action_id = c1rec.assignment_action_id --rev
5741: and act.payroll_action_id = pac.payroll_action_id
5742: and pev.element_entry_id = c1rec.element_entry_id
5743: and pac.date_earned between