DBA Data[Home] [Help]

APPS.PAY_IN_SOE dependencies on PAY_PAYROLL_ACTIONS

Line 1211: FROM pay_assignment_actions paa1,pay_action_interlocks intl,pay_payroll_actions ppa1

1207: AND paa.payroll_action_id = pai.action_context_id
1208: AND paa.assignment_id = nvl(pai.assignment_id,paa.assignment_id)
1209: AND EXISTS
1210: (SELECT ppa1.pay_advice_message
1211: FROM pay_assignment_actions paa1,pay_action_interlocks intl,pay_payroll_actions ppa1
1212: WHERE intl.locking_action_id = paa.assignment_action_id
1213: AND intl.locked_action_id = paa1.assignment_action_id
1214: AND paa1.payroll_action_id = ppa1.payroll_action_id
1215: AND ppa1.pay_advice_message IS NOT NULL