eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PYSG8SAD_XMLP_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 246: from pay_assignment_actions

242:
243: cursor c_get_asact_id
244: (c_pact_id in pay_payroll_actions.payroll_action_id%type) is
245: select distinct assignment_action_id
246: from pay_assignment_actions
247: where payroll_action_id = t_payroll_action_id;
248:
249: cursor c_get_arch_item_id
250: (c_asact_id pay_assignment_actions.assignment_action_id%type) is

Line 250: (c_asact_id pay_assignment_actions.assignment_action_id%type) is

246: from pay_assignment_actions
247: where payroll_action_id = t_payroll_action_id;
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:

Line 256: TYPE t_asact_id_tab IS TABLE OF pay_assignment_actions.assignment_action_id%type;

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;
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;