DBA Data[Home] [Help]

APPS.HR_JPRTS dependencies on PAY_ACTION_INTERLOCKS

Line 555: -- pay_action_interlocks RINTL

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

Line 583: pay_action_interlocks RINTL

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