APPS.PAY_VOID_REVERSAL_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 475: pay_pre_payments ppp, pay_action_interlocks pal

471: into l_prepayment_asg_action, l_payroll_id, l_assignment_id,
472: l_pre_payment_id, l_serial_number
473: from pay_payroll_actions ppa, pay_assignment_actions paa,
474: pay_assignment_actions paa2, pay_all_payrolls_f papf,
475: pay_pre_payments ppp, pay_action_interlocks pal
476: where pal.locking_action_id = p_check_assignment_action
477: and paa2.assignment_action_id = p_check_assignment_action
478: and paa.assignment_action_id = pal.locked_action_id
479: and ppa.payroll_action_id = paa.payroll_action_id

Line 554: from pay_action_interlocks pal1,

550: );
551: --
552: CURSOR get_pay_run_asg_action(p_check_assignment_action varchar2)
553: IS ( select pal2.locked_action_id
554: from pay_action_interlocks pal1,
555: pay_action_interlocks pal2
556: where pal1.locking_action_id = p_check_assignment_action
557: and pal1.locked_action_id = pal2.locking_action_id ) ;
558: --

Line 555: pay_action_interlocks pal2

551: --
552: CURSOR get_pay_run_asg_action(p_check_assignment_action varchar2)
553: IS ( select pal2.locked_action_id
554: from pay_action_interlocks pal1,
555: pay_action_interlocks pal2
556: where pal1.locking_action_id = p_check_assignment_action
557: and pal1.locked_action_id = pal2.locking_action_id ) ;
558: --
559: payroll_action_rec payroll_action_rectype;

Line 633: pay_action_interlocks pai

629: select distinct 1
630: into l_temp
631: from pay_assignment_actions ac2,
632: pay_payroll_actions pa2,
633: pay_action_interlocks pai
634: where pai.locked_action_id = l_payroll_run_asg_action
635: and ac2.assignment_action_id = pai.locking_action_id
636: and pa2.payroll_action_id = ac2.payroll_action_id
637: and pa2.action_type = 'V';