DBA Data[Home] [Help]

APPS.PAY_SA_PAYMENT_STATUS_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 45: from pay_action_interlocks ai

41: from pay_assignment_actions paa
42: where paa.assignment_action_id = p_assignment_action_id
43: and not exists
44: (select 1
45: from pay_action_interlocks ai
46: where ai.locking_action_id = paa.assignment_action_id )
47: and exists
48: (select 1 from pay_assignment_actions paa2,
49: pay_payroll_actions ppa2

Line 63: FROM pay_action_interlocks pai

59: and action_information3 in ('E','D');
60:
61: cursor c_get_prepay_id(p_assignment_action_id in number) is
62: SELECT paa.assignment_action_id,ppp.pre_payment_id
63: FROM pay_action_interlocks pai
64: ,pay_assignment_actions paa
65: ,pay_payroll_actions ppa
66: ,pay_pre_payments ppp
67: WHERE pai.locked_action_id = paa.assignment_action_id