DBA Data[Home] [Help]

APPS.PAY_SA_PAYMENT_STATUS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 49: pay_payroll_actions ppa2

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
50: where paa2.assignment_id = paa.assignment_id
51: and paa2.payroll_action_id = ppa2.payroll_action_id
52: and ppa2.action_type = 'Z');
53:

Line 65: ,pay_payroll_actions ppa

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
68: AND paa.payroll_action_id = ppa.payroll_action_id
69: AND ppa.action_type in ('P','U')