APPS.PY_ROLLBACK_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 245: delete from pay_element_entry_values_f pev

241: end if;
242: --
243: /* Delete the entry values before the element entry */
244: for ceevrec in ceev loop
245: delete from pay_element_entry_values_f pev
246: where element_entry_id = ceevrec.element_entry_id;
247: --
248: delete from pay_element_entries_f
249: where creator_id = p_assact_id

Line 281: delete from pay_element_entry_values_f pev

277: end if;
278: --
279: /* Delete the entry values before the element entry */
280: for aeevrec in aeev loop
281: delete from pay_element_entry_values_f pev
282: where element_entry_id = aeevrec.element_entry_id;
283: --
284: delete from pay_element_entries_f
285: where creator_id = p_assact_id

Line 315: delete from pay_element_entry_values_f pev

311: end if;
312: --
313: /* Delete the entry values before the element entry */
314: for aeevrec in aeev loop
315: delete from pay_element_entry_values_f pev
316: where element_entry_id = aeevrec.element_entry_id;
317: --
318: delete from pay_element_entries_f
319: where creator_id = p_assact_id

Line 348: delete from pay_element_entry_values_f pev

344: end if;
345: --
346: /* Delete the entry values before the element entry */
347: for raeevrec in raeev loop
348: delete from pay_element_entry_values_f pev
349: where element_entry_id = raeevrec.element_entry_id;
350: --
351: delete from pay_element_entries_f
352: where creator_id = p_assact_id

Line 391: delete from pay_element_entry_values_f pev

387: end if;
388: --
389: /* Delete the entry values before the element entry */
390: for eev_rec in remove_eev loop
391: delete from pay_element_entry_values_f pev
392: where element_entry_id = eev_rec.element_entry_id;
393: --
394: delete from pay_entry_process_details
395: where element_entry_id = eev_rec.element_entry_id;

Line 1010: delete from pay_element_entry_values_f pev

1006: hr_utility.set_location('undo_bal_adjust', 60);
1007: end if;
1008: for c1rec in c1 loop
1009: -- Now, we attempt to delete the entry values.
1010: delete from pay_element_entry_values_f pev
1011: where pev.element_entry_id = c1rec.element_entry_id
1012: and p_action_date between
1013: pev.effective_start_date and pev.effective_end_date;
1014: --

Line 1405: delete from pay_element_entry_values_f eev

1401: where ee.element_entry_id = p_ee_id
1402: and ee.effective_start_date = val_start;
1403: --
1404: hr_utility.set_location(c_indent, 45);
1405: delete from pay_element_entry_values_f eev
1406: where eev.element_entry_id = p_ee_id
1407: and eev.effective_start_date = val_start;
1408: --
1409: hr_utility.set_location(c_indent, 50);

Line 1416: update pay_element_entry_values_f eev

1412: where ee.element_entry_id = p_ee_id
1413: and ee.effective_start_date = effstart;
1414: --
1415: hr_utility.set_location(c_indent, 55);
1416: update pay_element_entry_values_f eev
1417: set eev.effective_end_date = next_end
1418: where eev.element_entry_id = p_ee_id
1419: and eev.effective_start_date = effstart;
1420: --

Line 1429: delete from pay_element_entry_values_f eev

1425: where ee.element_entry_id = p_ee_id
1426: and ee.effective_start_date > effstart;
1427: --
1428: hr_utility.set_location(c_indent, 65);
1429: delete from pay_element_entry_values_f eev
1430: where eev.element_entry_id = p_ee_id
1431: and eev.effective_start_date > effstart;
1432: --
1433: hr_utility.set_location(c_indent, 70);

Line 1459: update pay_element_entry_values_f eev

1455: end if;
1456: /*End of BUG#6200530*/
1457: --
1458: hr_utility.set_location(c_indent, 75);
1459: update pay_element_entry_values_f eev
1460: set eev.effective_end_date = max_end
1461: where eev.element_entry_id = p_ee_id
1462: and eev.effective_start_date = effstart;
1463: end if;