APPS.PAY_ASSIGNMENT_ACTIONS_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 128: -- pay_payroll_actions pact

124: -- cursor c_is_voided ( p_assignment_action_id in number ) is
125: -- select intloc.locking_action_id
126: -- from pay_assignment_actions assact,
127: -- pay_action_interlocks intloc,
128: -- pay_payroll_actions pact
129: -- where intloc.locked_action_id = p_assignment_action_id
130: -- and intloc.locking_action_id = assact.assignment_action_id
131: -- and assact.payroll_action_id = pact.payroll_action_id
132: -- and pact.action_type = 'D';

Line 137: -- pay_payroll_actions ppa,

133: -- --
134: -- cursor run_modified (p_assignment_action_id in number ) is
135: -- select paa.assignment_action_id
136: -- from
137: -- pay_payroll_actions ppa,
138: -- pay_assignment_actions paa
139: -- where paa.assignment_action_id = p_assignment_action_id
140: -- and paa.payroll_action_id = ppa.payroll_action_id
141: -- and paa.action_status = 'C'

Line 162: -- pay_payroll_actions ppa,

158: -- --
159: -- cursor prepay_modified (p_assignment_action_id in number ) is
160: -- select paa.assignment_action_id
161: -- from
162: -- pay_payroll_actions ppa,
163: -- pay_assignment_actions paa
164: -- where paa.assignment_action_id = p_assignment_action_id
165: -- and paa.payroll_action_id = ppa.payroll_action_id
166: -- and paa.action_status = 'C'

Line 183: -- pay_payroll_actions ppa2

179: -- or
180: -- exists (select ''
181: -- from pay_action_interlocks pai,
182: -- pay_assignment_actions paa2,
183: -- pay_payroll_actions ppa2
184: -- where pai.locking_action_id = paa.assignment_action_id
185: -- and pai.locked_action_id = paa2.assignment_action_id
186: -- and paa2.payroll_action_id = ppa2.payroll_action_id
187: -- and ppa2.action_type in ('R','Q')

Line 201: -- pay_payroll_actions ppa,

197: -- --
198: -- cursor cost_modified (p_assignment_action_id in number ) is
199: -- select paa.assignment_action_id
200: -- from
201: -- pay_payroll_actions ppa,
202: -- pay_assignment_actions paa
203: -- where paa.assignment_action_id = p_assignment_action_id
204: -- and paa.payroll_action_id = ppa.payroll_action_id
205: -- and paa.action_status = 'C'

Line 221: -- pay_payroll_actions ppa2

217: -- )
218: -- and exists (select ''
219: -- from pay_action_interlocks pai,
220: -- pay_assignment_actions paa2,
221: -- pay_payroll_actions ppa2
222: -- where pai.locking_action_id = paa.assignment_action_id
223: -- and pai.locked_action_id = paa2.assignment_action_id
224: -- and paa2.payroll_action_id = ppa2.payroll_action_id
225: -- and ppa2.action_type in ('R','Q')

Line 346: from pay_payroll_actions pac,

342: p_pre_payment_id number ) is
343: select aac.assignment_action_id,
344: aac.action_status,
345: pac.action_type
346: from pay_payroll_actions pac,
347: pay_assignment_actions aac,
348: pay_action_interlocks loc
349: where loc.locked_action_id = p_assignment_action_id
350: and loc.locking_action_id = aac.assignment_action_id

Line 361: from pay_payroll_actions pac,

357: -- check action.
358: --
359: cursor get_locking_void_action ( p_assignment_action_id number ) is
360: select aac.assignment_action_id
361: from pay_payroll_actions pac,
362: pay_assignment_actions aac,
363: pay_action_interlocks loc
364: where loc.locked_action_id = p_assignment_action_id
365: and loc.locking_action_id = aac.assignment_action_id