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

Line 182: FROM pay_action_interlocks pail

178: and pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES' --3098353
179: and pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO' --3937976
180: and not exists
181: (select locked_action_id
182: FROM pay_action_interlocks pail
183: WHERE pail.locked_action_id=ppac.assignment_action_id)
184: and ppac.assignment_action_id in
185: (select max(ppac1.assignment_action_id)
186: from pay_assignment_actions ppac1,

Line 240: FROM pay_action_interlocks pail

236: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
237: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO'
238: AND NOT EXISTS
239: (SELECT locked_action_id
240: FROM pay_action_interlocks pail
241: WHERE pail.locked_action_id = ppac.assignment_action_id)
242: AND ppac.assignment_action_id IN
243: (SELECT MAX(ppac1.assignment_action_id)
244: FROM pay_assignment_actions ppac1,

Line 319: FROM pay_action_interlocks pail

315: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pmpa.legislative_parameters) = c_reg_emp
316: AND pay_core_utils.get_parameter('FINANCIAL_YEAR', pmpa.legislative_parameters) = c_financial_year
317: AND NOT EXISTS
318: (SELECT locked_action_id
319: FROM pay_action_interlocks pail
320: WHERE pail.locked_action_id=ppac.assignment_action_id)
321: AND NOT EXISTS /* bug 14621185 - restricting to return the latest archive only */
322: (SELECT locked_action_id
323: FROM pay_action_interlocks pail

Line 323: FROM pay_action_interlocks pail

319: FROM pay_action_interlocks pail
320: WHERE pail.locked_action_id=ppac.assignment_action_id)
321: AND NOT EXISTS /* bug 14621185 - restricting to return the latest archive only */
322: (SELECT locked_action_id
323: FROM pay_action_interlocks pail
324: WHERE pail.locked_action_id=pmaa.assignment_action_id)
325: AND ppac.assignment_action_id IN
326: (SELECT MAX(ppac1.assignment_action_id)
327: FROM pay_assignment_actions ppac1,

Line 381: FROM pay_action_interlocks pail

377: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pmpa.legislative_parameters) = c_reg_emp
378: AND pay_core_utils.get_parameter('FINANCIAL_YEAR', pmpa.legislative_parameters) = c_financial_year
379: AND NOT EXISTS
380: (SELECT locked_action_id
381: FROM pay_action_interlocks pail
382: WHERE pail.locked_action_id=ppac.assignment_action_id)
383: AND NOT EXISTS /* bug 14621185 - restricting to return the latest archive only */
384: (SELECT locked_action_id
385: FROM pay_action_interlocks pail

Line 385: FROM pay_action_interlocks pail

381: FROM pay_action_interlocks pail
382: WHERE pail.locked_action_id=ppac.assignment_action_id)
383: AND NOT EXISTS /* bug 14621185 - restricting to return the latest archive only */
384: (SELECT locked_action_id
385: FROM pay_action_interlocks pail
386: WHERE pail.locked_action_id=pmaa.assignment_action_id)
387: AND ppac.assignment_action_id IN
388: (SELECT MAX(ppac1.assignment_action_id)
389: FROM pay_assignment_actions ppac1,