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_AU_PAYMENT_SUMMARY_MAGTAPE dependencies on PAY_ACTION_INTERLOCKS

Line 66: pay_action_interlocks ppai,

62: from pay_assignment_actions apac,
63: pay_assignment_actions ppac,
64: pay_payroll_actions ppa,
65: pay_assignment_actions mpac,
66: pay_action_interlocks ppai,
67: pay_action_interlocks mpai
68: where apac.assignment_action_id = ppai.locked_action_id
69: and mpac.assignment_Action_id = mpai.locking_action_id
70: and ppa.payroll_action_id = ppac.payroll_Action_id

Line 67: pay_action_interlocks mpai

63: pay_assignment_actions ppac,
64: pay_payroll_actions ppa,
65: pay_assignment_actions mpac,
66: pay_action_interlocks ppai,
67: pay_action_interlocks mpai
68: where apac.assignment_action_id = ppai.locked_action_id
69: and mpac.assignment_Action_id = mpai.locking_action_id
70: and ppa.payroll_action_id = ppac.payroll_Action_id
71: and apac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)

Line 132: pay_action_interlocks mpai,

128: -- ,'ETP_PAYER_TYPE=P',
129: -- ,decode(fue.user_entity_name,'X_LUMP_SUM_C_DEDUCTIONS_ASG_YTD',decode(value ,0,null ,null,null, 'P')) etp_payer_type
130: from
131: pay_assignment_actions mpac, --magtape
132: pay_action_interlocks mpai,
133: pay_assignment_actions ppac, --self printed
134: pay_action_interlocks ppai,
135: pay_assignment_actions apac, --archive
136: pay_payroll_actions ppa, --self printed

Line 134: pay_action_interlocks ppai,

130: from
131: pay_assignment_actions mpac, --magtape
132: pay_action_interlocks mpai,
133: pay_assignment_actions ppac, --self printed
134: pay_action_interlocks ppai,
135: pay_assignment_actions apac, --archive
136: pay_payroll_actions ppa, --self printed
137: ff_archive_items ff,
138: ff_user_entities fue

Line 197: pay_action_interlocks mpai,

193: cursor payment_summary_data is /* 5471093 */
194: select /*+ ORDERED */ 'ASSIGNMENT_ACTION_ID=C',
195: apac.assignment_action_id ps_report_id
196: from pay_assignment_actions mpac,
197: pay_action_interlocks mpai,
198: pay_assignment_actions ppac,
199: pay_action_interlocks ppai,
200: pay_assignment_actions apac,
201: pay_payroll_actions ppa

Line 199: pay_action_interlocks ppai,

195: apac.assignment_action_id ps_report_id
196: from pay_assignment_actions mpac,
197: pay_action_interlocks mpai,
198: pay_assignment_actions ppac,
199: pay_action_interlocks ppai,
200: pay_assignment_actions apac,
201: pay_payroll_actions ppa
202: where ppa.payroll_action_id = ppac.payroll_Action_id
203: and apac.assignment_action_id = ppai.locked_action_id

Line 281: pay_action_interlocks mpai,

277: select /*+ORDERED*/ 'ASSIGNMENT_ACTION_ID=C',
278: apac.assignment_action_id ps_report_id
279: from
280: pay_assignment_actions mpac, -- Magtape
281: pay_action_interlocks mpai,
282: pay_assignment_actions ppac, --Self Printed
283: pay_action_interlocks ppai,
284: pay_assignment_actions apac, --Archive
285: pay_payroll_actions ppa --Self Printed

Line 283: pay_action_interlocks ppai,

279: from
280: pay_assignment_actions mpac, -- Magtape
281: pay_action_interlocks mpai,
282: pay_assignment_actions ppac, --Self Printed
283: pay_action_interlocks ppai,
284: pay_assignment_actions apac, --Archive
285: pay_payroll_actions ppa --Self Printed
286: where mpac.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
287: and mpac.action_status = 'C'