APPS.PAY_PYSG8SAD_XMLP_PKG dependencies on FF_ARCHIVE_ITEMS

Line 252: from ff_archive_items

248:
249: cursor c_get_arch_item_id
250: (c_asact_id pay_assignment_actions.assignment_action_id%type) is
251: select distinct archive_item_id
252: from ff_archive_items
253: where context1= c_asact_id;
254:
255:
256: TYPE t_asact_id_tab IS TABLE OF pay_assignment_actions.assignment_action_id%type;

Line 259: TYPE t_arch_item_id_tab IS TABLE OF ff_archive_items.archive_item_id%type;

255:
256: TYPE t_asact_id_tab IS TABLE OF pay_assignment_actions.assignment_action_id%type;
257: asact_id_list t_asact_id_tab;
258:
259: TYPE t_arch_item_id_tab IS TABLE OF ff_archive_items.archive_item_id%type;
260: arc_item_id_list t_arch_item_id_tab;
261:
262: v_archive_item_id ff_archive_items.archive_item_id%type;
263:

Line 262: v_archive_item_id ff_archive_items.archive_item_id%type;

258:
259: TYPE t_arch_item_id_tab IS TABLE OF ff_archive_items.archive_item_id%type;
260: arc_item_id_list t_arch_item_id_tab;
261:
262: v_archive_item_id ff_archive_items.archive_item_id%type;
263:
264:
265: BEGIN
266: for process_rec in c_get_asact_id(t_payroll_action_id)

Line 273: delete from ff_archive_items where archive_item_id = v_archive_item_id;

269: loop
270: fetch c_get_arch_item_id into v_archive_item_id;
271: exit when c_get_arch_item_id%NOTFOUND;
272: delete from ff_archive_item_contexts where archive_item_id = v_archive_item_id;
273: delete from ff_archive_items where archive_item_id = v_archive_item_id;
274: end loop;
275: close c_get_arch_item_id;
276: end loop;
277: pay_archive.remove_report_actions(t_payroll_action_id);