APPS.PAY_JP_IWHT_ARCH_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 663: pay_action_interlocks PAI

659: AND NOT EXISTS(
660: SELECT null
661: FROM pay_payroll_actions PPAV,
662: pay_assignment_actions PAAV,
663: pay_action_interlocks PAI
664: WHERE PAI.locked_action_id = PAA.assignment_action_id
665: AND PAAV.assignment_action_id = PAI.locking_action_id
666: AND PPAV.payroll_action_id = PAAV.payroll_action_id
667: AND PPAV.action_type = 'V'))

Line 716: pay_action_interlocks PAI

712: AND NOT EXISTS(
713: SELECT null
714: FROM pay_payroll_actions PPAV,
715: pay_assignment_actions PAAV,
716: pay_action_interlocks PAI
717: WHERE PAI.locked_action_id = PAA.assignment_action_id
718: AND PAAV.assignment_action_id = PAI.locking_action_id
719: AND PPAV.payroll_action_id = PAAV.payroll_action_id
720: AND PPAV.action_type = 'V'))

Line 997: pay_action_interlocks PAI

993: AND NOT EXISTS(
994: SELECT null
995: FROM pay_payroll_actions PPAV,
996: pay_assignment_actions PAAV,
997: pay_action_interlocks PAI
998: WHERE PAI.locked_action_id = PAA.assignment_action_id
999: AND PAAV.assignment_action_id = PAI.locking_action_id
1000: AND PPAV.payroll_action_id = PAAV.payroll_action_id
1001: AND PPAV.action_type = 'V'))

Line 1054: pay_action_interlocks PAI

1050: AND NOT EXISTS(
1051: SELECT null
1052: FROM pay_payroll_actions PPAV,
1053: pay_assignment_actions PAAV,
1054: pay_action_interlocks PAI
1055: WHERE PAI.locked_action_id = PAA.assignment_action_id
1056: AND PAAV.assignment_action_id = PAI.locking_action_id
1057: AND PPAV.payroll_action_id = PAAV.payroll_action_id
1058: AND PPAV.action_type = 'V');

Line 1082: pay_action_interlocks PAI

1078: AND NOT EXISTS(
1079: SELECT null
1080: FROM pay_payroll_actions PPAV,
1081: pay_assignment_actions PAAV,
1082: pay_action_interlocks PAI
1083: WHERE PAI.locked_action_id = PAA.assignment_action_id
1084: AND PAAV.assignment_action_id = PAI.locking_action_id
1085: AND PPAV.payroll_action_id = PAAV.payroll_action_id
1086: AND PPAV.action_type = 'V');