DBA Data[Home] [Help]

APPS.PAY_SA_SOE dependencies on PAY_PAYROLL_ACTIONS

Line 189: from pay_payroll_actions pa

185: , aa.assignment_id
186: , pa.business_group_id
187: , bg.legislation_code
188: , lrl.rule_mode
189: from pay_payroll_actions pa
190: , pay_assignment_actions aa
191: , per_business_groups bg
192: , pay_legislation_rules lrl
193: where aa.assignment_action_id = p_assignment_action_id

Line 202: from pay_payroll_actions pa

198: --
199: --
200: cursor getParameters(c_assignment_action_id in number) is
201: select '''' || bg.currency_code || '''' currency_code
202: from pay_payroll_actions pa
203: , pay_assignment_actions aa
204: , per_business_groups bg
205: where aa.assignment_action_id = p_assignment_action_id
206: and aa.payroll_action_id = pa.payroll_action_id

Line 257: , pay_payroll_actions pa

253: , rb.SOURCE_NUMBER
254: , rb.SOURCE_TEXT2
255: from pay_run_balances rb
256: , pay_assignment_actions aa
257: , pay_payroll_actions pa
258: where rb.ASSIGNMENT_ID = l_assignment_id
259: and l_action_sequence >= aa.action_sequence
260: and rb.assignment_action_id = aa.assignment_action_id
261: and aa.payroll_action_id = pa.payroll_action_id

Line 285: pay_payroll_actions pa,

281: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
282: ,rr.run_result_id)
283: ,null) source_text2
284: from pay_assignment_actions aa,
285: pay_payroll_actions pa,
286: pay_run_results rr
287: where aa.ASSIGNMENT_ID = l_assignment_id
288: and aa.assignment_action_id = rr.assignment_action_id
289: and l_action_sequence >= aa.action_sequence