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

Line 302: ,pay_action_interlocks pai

298: ( /* Check if a locked Amended Payment Summary does not exist for this year */
299: SELECT '1'
300: FROM pay_payroll_actions ppa2
301: ,pay_assignment_actions paa2
302: ,pay_action_interlocks pai
303: WHERE ppa2.payroll_action_id = paa2.payroll_action_id
304: AND ppa2.report_type = 'AU_PAY_SUMM_AMEND'
305: AND ppa2.report_qualifier = 'AU'
306: AND ppa2.report_category = 'REPORT'

Line 382: ,pay_action_interlocks pai

378: ( /* Check if a locked Amended Payment Summary does not exist for this year */
379: SELECT '1'
380: FROM pay_payroll_actions ppa2
381: ,pay_assignment_actions paa2
382: ,pay_action_interlocks pai
383: WHERE ppa2.payroll_action_id = paa2.payroll_action_id
384: AND ppa2.report_type = 'AU_PAY_SUMM_AMEND'
385: AND ppa2.report_qualifier = 'AU'
386: AND ppa2.report_category = 'REPORT'

Line 482: INDEX(PAI PAY_ACTION_INTERLOCKS_FK2) */

478: SELECT /*+ ORDERED
479: USE_NL(PPA2, PAA2, PAI)
480: INDEX(PPA2 PAY_PAYROLL_ACTIONS_N52)
481: INDEX(PAA2 PAY_ASSIGNMENT_ACTIONS_N51)
482: INDEX(PAI PAY_ACTION_INTERLOCKS_FK2) */
483: '1'
484: FROM pay_payroll_actions ppa2,
485: pay_assignment_actions paa2,
486: pay_action_interlocks pai

Line 486: pay_action_interlocks pai

482: INDEX(PAI PAY_ACTION_INTERLOCKS_FK2) */
483: '1'
484: FROM pay_payroll_actions ppa2,
485: pay_assignment_actions paa2,
486: pay_action_interlocks pai
487: WHERE ppa2.report_type = 'AU_PAY_SUMM_AMEND'
488: AND ppa2.report_qualifier = 'AU'
489: AND ppa2.report_category = 'REPORT'
490: AND pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa2.legislative_parameters) = c_financial_year

Line 2176: ,pay_action_interlocks mplock

2172: IS
2173: SELECT selfplock.locked_action_id
2174: FROM pay_assignment_actions mpaa
2175: ,pay_payroll_actions mppa
2176: ,pay_action_interlocks mplock
2177: ,pay_action_interlocks selfplock
2178: WHERE mpaa.assignment_id = c_assignmenr_id
2179: AND mpaa.payroll_action_id = mppa.payroll_action_id
2180: AND mppa.report_type = 'AU_PS_DATA_FILE'

Line 2177: ,pay_action_interlocks selfplock

2173: SELECT selfplock.locked_action_id
2174: FROM pay_assignment_actions mpaa
2175: ,pay_payroll_actions mppa
2176: ,pay_action_interlocks mplock
2177: ,pay_action_interlocks selfplock
2178: WHERE mpaa.assignment_id = c_assignmenr_id
2179: AND mpaa.payroll_action_id = mppa.payroll_action_id
2180: AND mppa.report_type = 'AU_PS_DATA_FILE'
2181: AND mppa.report_qualifier = 'AU'