DBA Data[Home] [Help]

APPS.PAY_BALANCE_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 502: pay_action_interlocks pai

498: select min(effective_date)
499: into l_return_date
500: from pay_payroll_actions ppa,
501: pay_assignment_actions paa,
502: pay_action_interlocks pai
503: where pai.locking_action_id = p_asg_action
504: and pai.locked_action_id = paa.assignment_action_id
505: and paa.payroll_action_id = ppa.payroll_action_id;
506: else

Line 649: pay_action_interlocks pai

645: select max(effective_date)
646: into l_return_date
647: from pay_payroll_actions ppa,
648: pay_assignment_actions paa,
649: pay_action_interlocks pai
650: where pai.locking_action_id = p_asg_action
651: and pai.locked_action_id = paa.assignment_action_id
652: and paa.payroll_action_id = ppa.payroll_action_id;
653: else