DBA Data[Home] [Help]

APPS.PAY_BALANCE_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 576: pay_action_interlocks pai

572: select min(effective_date)
573: into l_return_date
574: from pay_payroll_actions ppa,
575: pay_assignment_actions paa,
576: pay_action_interlocks pai
577: where pai.locking_action_id = p_asg_action
578: and pai.locked_action_id = paa.assignment_action_id
579: and paa.payroll_action_id = ppa.payroll_action_id;
580: else

Line 739: pay_action_interlocks pai

735: select max(effective_date)
736: into l_return_date
737: from pay_payroll_actions ppa,
738: pay_assignment_actions paa,
739: pay_action_interlocks pai
740: where pai.locking_action_id = p_asg_action
741: and pai.locked_action_id = paa.assignment_action_id
742: and paa.payroll_action_id = ppa.payroll_action_id;
743: else