DBA Data[Home] [Help]

APPS.PAY_KR_SEP_ARCHIVE_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 826: pay_action_interlocks pai

822: and not exists(
823: select 'x'
824: from pay_payroll_actions appa,
825: pay_assignment_actions apaa,
826: pay_action_interlocks pai
827: where pai.locked_action_id = paa.assignment_action_id
828: and apaa.assignment_action_id = pai.locking_action_id
829: and appa.payroll_action_id = apaa.payroll_action_id
830: and appa.action_type = 'X'

Line 947: pay_action_interlocks pai,

943: ppa.date_earned,
944: paa.tax_unit_id
945: from pay_payroll_actions ppa,
946: pay_assignment_actions paa,
947: pay_action_interlocks pai,
948: pay_assignment_actions xpaa
949: where xpaa.assignment_action_id = p_assignment_action_id
950: and pai.locking_action_id = xpaa.assignment_action_id
951: and paa.assignment_action_id = pai.locked_action_id