APPS.PY_ROLLBACK_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 250: delete from pay_element_entry_values_f pev

246: end if;
247: --
248: /* Delete the entry values before the element entry */
249: for ceevrec in ceev loop
250: delete from pay_element_entry_values_f pev
251: where element_entry_id = ceevrec.element_entry_id;
252: --
253: delete from pay_element_entries_f
254: where creator_id = p_assact_id

Line 286: delete from pay_element_entry_values_f pev

282: end if;
283: --
284: /* Delete the entry values before the element entry */
285: for aeevrec in aeev loop
286: delete from pay_element_entry_values_f pev
287: where element_entry_id = aeevrec.element_entry_id;
288: --
289: delete from pay_element_entries_f
290: where creator_id = p_assact_id

Line 320: delete from pay_element_entry_values_f pev

316: end if;
317: --
318: /* Delete the entry values before the element entry */
319: for aeevrec in aeev loop
320: delete from pay_element_entry_values_f pev
321: where element_entry_id = aeevrec.element_entry_id;
322: --
323: delete from pay_element_entries_f
324: where creator_id = p_assact_id

Line 353: delete from pay_element_entry_values_f pev

349: end if;
350: --
351: /* Delete the entry values before the element entry */
352: for raeevrec in raeev loop
353: delete from pay_element_entry_values_f pev
354: where element_entry_id = raeevrec.element_entry_id;
355: --
356: delete from pay_element_entries_f
357: where creator_id = p_assact_id

Line 396: delete from pay_element_entry_values_f pev

392: end if;
393: --
394: /* Delete the entry values before the element entry */
395: for eev_rec in remove_eev loop
396: delete from pay_element_entry_values_f pev
397: where element_entry_id = eev_rec.element_entry_id;
398: --
399: delete from pay_entry_process_details
400: where element_entry_id = eev_rec.element_entry_id;

Line 1015: delete from pay_element_entry_values_f pev

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

Line 1410: delete from pay_element_entry_values_f eev

1406: where ee.element_entry_id = p_ee_id
1407: and ee.effective_start_date = val_start;
1408: --
1409: hr_utility.set_location(c_indent, 45);
1410: delete from pay_element_entry_values_f eev
1411: where eev.element_entry_id = p_ee_id
1412: and eev.effective_start_date = val_start;
1413: --
1414: hr_utility.set_location(c_indent, 50);

Line 1421: update pay_element_entry_values_f eev

1417: where ee.element_entry_id = p_ee_id
1418: and ee.effective_start_date = effstart;
1419: --
1420: hr_utility.set_location(c_indent, 55);
1421: update pay_element_entry_values_f eev
1422: set eev.effective_end_date = next_end
1423: where eev.element_entry_id = p_ee_id
1424: and eev.effective_start_date = effstart;
1425: --

Line 1434: delete from pay_element_entry_values_f eev

1430: where ee.element_entry_id = p_ee_id
1431: and ee.effective_start_date > effstart;
1432: --
1433: hr_utility.set_location(c_indent, 65);
1434: delete from pay_element_entry_values_f eev
1435: where eev.element_entry_id = p_ee_id
1436: and eev.effective_start_date > effstart;
1437: --
1438: hr_utility.set_location(c_indent, 70);

Line 1464: update pay_element_entry_values_f eev

1460: end if;
1461: /*End of BUG#6200530*/
1462: --
1463: hr_utility.set_location(c_indent, 75);
1464: update pay_element_entry_values_f eev
1465: set eev.effective_end_date = max_end
1466: where eev.element_entry_id = p_ee_id
1467: and eev.effective_start_date = effstart;
1468: end if;