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_CORE_UTILS

Line 120: SELECT pay_core_utils.get_parameter('IS_TESTING',ppa.legislative_parameters),

116:
117:
118: CURSOR get_parameters
119: IS
120: SELECT pay_core_utils.get_parameter('IS_TESTING',ppa.legislative_parameters),
121: pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters),
122: pay_core_utils.get_parameter('PAYMENT_SUMMARY_TYPE',ppa.legislative_parameters) /* bug 6630375 */
123: FROM pay_payroll_actions ppa
124: WHERE ppa.payroll_Action_id = p_payroll_action_id;

Line 121: pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters),

117:
118: CURSOR get_parameters
119: IS
120: SELECT pay_core_utils.get_parameter('IS_TESTING',ppa.legislative_parameters),
121: pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters),
122: pay_core_utils.get_parameter('PAYMENT_SUMMARY_TYPE',ppa.legislative_parameters) /* bug 6630375 */
123: FROM pay_payroll_actions ppa
124: WHERE ppa.payroll_Action_id = p_payroll_action_id;
125:

Line 122: pay_core_utils.get_parameter('PAYMENT_SUMMARY_TYPE',ppa.legislative_parameters) /* bug 6630375 */

118: CURSOR get_parameters
119: IS
120: SELECT pay_core_utils.get_parameter('IS_TESTING',ppa.legislative_parameters),
121: pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters),
122: pay_core_utils.get_parameter('PAYMENT_SUMMARY_TYPE',ppa.legislative_parameters) /* bug 6630375 */
123: FROM pay_payroll_actions ppa
124: WHERE ppa.payroll_Action_id = p_payroll_action_id;
125:
126:

Line 200: AND apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)

196: AND apac.assignment_action_id = ppai.locked_action_id
197: AND ppac.assignment_action_id = ppai.locking_action_id
198: and apa.action_status = 'C'
199: AND ppa.action_status = 'C'
200: AND apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)
201: AND a.assignment_id = apac.assignment_id
202: AND a.assignment_id = ppac.assignment_id
203: AND apa.report_type ='AU_PAYMENT_SUMMARY'
204: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'

Line 205: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=

201: AND a.assignment_id = apac.assignment_id
202: AND a.assignment_id = ppac.assignment_id
203: AND apa.report_type ='AU_PAYMENT_SUMMARY'
204: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
205: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
206: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
207: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
208: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
209: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=

Line 206: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)

202: AND a.assignment_id = ppac.assignment_id
203: AND apa.report_type ='AU_PAYMENT_SUMMARY'
204: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
205: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
206: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
207: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
208: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
209: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
210: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)

Line 207: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=

203: AND apa.report_type ='AU_PAYMENT_SUMMARY'
204: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
205: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
206: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
207: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
208: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
209: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
210: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
211: AND NOT EXISTS /* 5471093 */

Line 208: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)

204: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
205: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
206: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
207: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
208: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
209: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
210: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
211: AND NOT EXISTS /* 5471093 */
212: (SELECT /*+ ORDERED */ locked_action_id

Line 209: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=

205: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
206: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
207: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
208: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
209: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
210: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
211: AND NOT EXISTS /* 5471093 */
212: (SELECT /*+ ORDERED */ locked_action_id
213: FROM pay_action_interlocks pail,

Line 210: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)

206: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
207: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
208: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
209: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
210: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
211: AND NOT EXISTS /* 5471093 */
212: (SELECT /*+ ORDERED */ locked_action_id
213: FROM pay_action_interlocks pail,
214: pay_assignment_actions paa1,

Line 270: AND apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)

266: AND apac.assignment_action_id = ppai.locked_action_id
267: AND ppac.assignment_action_id = ppai.locking_action_id
268: and apa.action_status = 'C'
269: AND ppa.action_status = 'C'
270: AND apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)
271: AND a.assignment_id = apac.assignment_id
272: AND a.assignment_id = ppac.assignment_id
273: AND apa.report_type ='AU_PAYMENT_SUMMARY'
274: AND apa.report_qualifier = 'AU'

Line 280: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=

276: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
277: AND ppa.report_qualifier = 'AU'
278: AND ppa.report_category = 'REPORT'
279: AND apa.business_group_id = mpa.business_group_id
280: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
281: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
282: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
283: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
284: AND NOT EXISTS /* 5471093 */

Line 281: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)

277: AND ppa.report_qualifier = 'AU'
278: AND ppa.report_category = 'REPORT'
279: AND apa.business_group_id = mpa.business_group_id
280: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
281: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
282: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
283: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
284: AND NOT EXISTS /* 5471093 */
285: (SELECT locked_action_id

Line 282: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=

278: AND ppa.report_category = 'REPORT'
279: AND apa.business_group_id = mpa.business_group_id
280: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
281: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
282: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
283: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
284: AND NOT EXISTS /* 5471093 */
285: (SELECT locked_action_id
286: FROM pay_action_interlocks pail,

Line 283: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)

279: AND apa.business_group_id = mpa.business_group_id
280: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
281: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
282: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
283: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
284: AND NOT EXISTS /* 5471093 */
285: (SELECT locked_action_id
286: FROM pay_action_interlocks pail,
287: pay_assignment_actions paa1,

Line 374: AND apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)

370: AND apac.assignment_action_id = ppai.locked_action_id
371: AND ppac.assignment_action_id = ppai.locking_action_id
372: and apa.action_status = 'C'
373: AND ppa.action_status = 'C'
374: AND apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)
375: AND a.assignment_id = apac.assignment_id
376: AND a.assignment_id = ppac.assignment_id
377: AND apa.report_type ='AU_PAY_SUMM_AMEND'
378: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'

Line 379: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=

375: AND a.assignment_id = apac.assignment_id
376: AND a.assignment_id = ppac.assignment_id
377: AND apa.report_type ='AU_PAY_SUMM_AMEND'
378: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
379: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
380: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
381: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
382: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
383: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=

Line 380: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)

376: AND a.assignment_id = ppac.assignment_id
377: AND apa.report_type ='AU_PAY_SUMM_AMEND'
378: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
379: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
380: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
381: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
382: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
383: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
384: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)

Line 381: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=

377: AND apa.report_type ='AU_PAY_SUMM_AMEND'
378: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
379: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
380: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
381: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
382: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
383: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
384: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
385: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'

Line 382: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)

378: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
379: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
380: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
381: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
382: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
383: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
384: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
385: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'
386: AND NOT EXISTS /* 5471093 */

Line 383: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=

379: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
380: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
381: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
382: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
383: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
384: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
385: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'
386: AND NOT EXISTS /* 5471093 */
387: (SELECT /*+ ORDERED */ locked_action_id

Line 384: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)

380: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
381: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
382: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
383: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
384: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
385: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'
386: AND NOT EXISTS /* 5471093 */
387: (SELECT /*+ ORDERED */ locked_action_id
388: FROM pay_action_interlocks pail,

Line 434: AND apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)

430: AND apac.assignment_action_id = ppai.locked_action_id
431: AND ppac.assignment_action_id = ppai.locking_action_id
432: and apa.action_status = 'C'
433: AND ppa.action_status = 'C'
434: AND apa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)
435: AND a.assignment_id = apac.assignment_id
436: AND a.assignment_id = ppac.assignment_id
437: AND apa.report_type ='AU_PAY_SUMM_AMEND'
438: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'

Line 439: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=

435: AND a.assignment_id = apac.assignment_id
436: AND a.assignment_id = ppac.assignment_id
437: AND apa.report_type ='AU_PAY_SUMM_AMEND'
438: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
439: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
440: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
441: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
442: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
443: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=

Line 440: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)

436: AND a.assignment_id = ppac.assignment_id
437: AND apa.report_type ='AU_PAY_SUMM_AMEND'
438: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
439: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
440: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
441: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
442: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
443: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
444: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)

Line 441: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=

437: AND apa.report_type ='AU_PAY_SUMM_AMEND'
438: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
439: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
440: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
441: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
442: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
443: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
444: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
445: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'

Line 442: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)

438: AND ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
439: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
440: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
441: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
442: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
443: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
444: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
445: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'
446: AND NOT EXISTS

Line 443: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=

439: AND pay_core_utils.get_parameter('BUSINESS_GROUP_ID',apa.legislative_parameters)=
440: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
441: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
442: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
443: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
444: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
445: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'
446: AND NOT EXISTS
447: (SELECT /*+ ORDERED */ locked_action_id

Line 444: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)

440: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',mpa.legislative_parameters)
441: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER',apa.legislative_parameters)=
442: pay_core_utils.get_parameter('REGISTERED_EMPLOYER',mpa.legislative_parameters)
443: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',apa.legislative_parameters)=
444: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
445: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'
446: AND NOT EXISTS
447: (SELECT /*+ ORDERED */ locked_action_id
448: FROM pay_action_interlocks pail,