DBA Data[Home] [Help]

APPS.PAY_FR_SICKNESS_CALC dependencies on PAY_ACTION_INTERLOCKS

Line 555: , pay_action_interlocks RINTLK

551: and NOT EXISTS
552: (SELECT NULL
553: FROM pay_payroll_actions RPACT
554: , pay_assignment_actions RASSACT
555: , pay_action_interlocks RINTLK
556: where ASSACT.assignment_action_id = RINTLK.locked_action_id
557: and RINTLK.locking_action_id = RASSACT.assignment_action_id
558: and RPACT.payroll_action_id = RASSACT.payroll_action_id
559: and RPACT.action_type = 'V' )

Line 2729: , pay_action_interlocks RINTLK

2725: and NOT EXISTS
2726: (SELECT 1
2727: FROM pay_payroll_actions RPACT
2728: , pay_assignment_actions RASSACT
2729: , pay_action_interlocks RINTLK
2730: where ASSACT.assignment_action_id = RINTLK.locked_action_id
2731: and RINTLK.locking_action_id = RASSACT.assignment_action_id
2732: and RPACT.payroll_action_id = RASSACT.payroll_action_id
2733: and RPACT.action_type = 'V' )