APPS.PAY_AU_PAYMENT_SUMMARY_AMEND dependencies on PAY_ACTION_INTERLOCKS

Line 222: ,pay_action_interlocks pai

218: ( /* Check if a locked Amended Payment Summary does not exist for this year */
219: SELECT '1'
220: FROM pay_payroll_actions ppa2
221: ,pay_assignment_actions paa2
222: ,pay_action_interlocks pai
223: WHERE ppa2.payroll_action_id = paa2.payroll_action_id
224: AND ppa2.report_type = 'AU_PAY_SUMM_AMEND'
225: AND ppa2.report_qualifier = 'AU'
226: AND ppa2.report_category = 'REPORT'

Line 271: ,pay_action_interlocks pai

267: ( /* Check if a locked Amended Payment Summary does not exist for this year */
268: SELECT '1'
269: FROM pay_payroll_actions ppa2
270: ,pay_assignment_actions paa2
271: ,pay_action_interlocks pai
272: WHERE ppa2.payroll_action_id = paa2.payroll_action_id
273: AND ppa2.report_type = 'AU_PAY_SUMM_AMEND'
274: AND ppa2.report_qualifier = 'AU'
275: AND ppa2.report_category = 'REPORT'

Line 1462: ,pay_action_interlocks mplock

1458: IS
1459: SELECT selfplock.locked_action_id
1460: FROM pay_assignment_actions mpaa
1461: ,pay_payroll_actions mppa
1462: ,pay_action_interlocks mplock
1463: ,pay_action_interlocks selfplock
1464: WHERE mpaa.assignment_id = c_assignmenr_id
1465: AND mpaa.payroll_action_id = mppa.payroll_action_id
1466: AND mppa.report_type = 'AU_PS_DATA_FILE'

Line 1463: ,pay_action_interlocks selfplock

1459: SELECT selfplock.locked_action_id
1460: FROM pay_assignment_actions mpaa
1461: ,pay_payroll_actions mppa
1462: ,pay_action_interlocks mplock
1463: ,pay_action_interlocks selfplock
1464: WHERE mpaa.assignment_id = c_assignmenr_id
1465: AND mpaa.payroll_action_id = mppa.payroll_action_id
1466: AND mppa.report_type = 'AU_PS_DATA_FILE'
1467: AND mppa.report_qualifier = 'AU'