DBA Data[Home] [Help]

APPS.PAY_KR_SEP_ARCHIVE_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 723: pay_action_interlocks pai

719: and not exists(
720: select 'x'
721: from pay_payroll_actions appa,
722: pay_assignment_actions apaa,
723: pay_action_interlocks pai
724: where pai.locked_action_id = paa.assignment_action_id
725: and apaa.assignment_action_id = pai.locking_action_id
726: and appa.payroll_action_id = apaa.payroll_action_id
727: and appa.action_type = 'X'

Line 844: pay_action_interlocks pai,

840: ppa.date_earned,
841: paa.tax_unit_id
842: from pay_payroll_actions ppa,
843: pay_assignment_actions paa,
844: pay_action_interlocks pai,
845: pay_assignment_actions xpaa
846: where xpaa.assignment_action_id = p_assignment_action_id
847: and pai.locking_action_id = xpaa.assignment_action_id
848: and paa.assignment_action_id = pai.locked_action_id