DBA Data[Home] [Help]

APPS.HR_JPRTS dependencies on PAY_ACTION_INTERLOCKS

Line 552: -- pay_action_interlocks RINTL

548: -- AND NOT EXISTS(
549: -- SELECT NULL
550: -- FROM pay_payroll_actions RPACT,
551: -- pay_assignment_actions RASSACT,
552: -- pay_action_interlocks RINTL
553: -- WHERE RINTL.locked_action_id = ASSACT.assignment_action_id
554: -- AND RASSACT.assignment_action_id = RINTL.locking_action_id
555: -- AND RPACT.payroll_action_id = RASSACT.payroll_action_id
556: -- AND RPACT.action_type = 'V');

Line 580: pay_action_interlocks RINTL

576: AND NOT EXISTS(
577: SELECT NULL
578: FROM pay_payroll_actions RPACT,
579: pay_assignment_actions RASSACT,
580: pay_action_interlocks RINTL
581: WHERE RINTL.locked_action_id = ASSACT.assignment_action_id
582: AND RASSACT.assignment_action_id = RINTL.locking_action_id
583: AND RPACT.payroll_action_id = RASSACT.payroll_action_id
584: AND RPACT.action_type = 'V')) V1,