DBA Data[Home] [Help]

APPS.PAY_SA_SOE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 187: , pay_assignment_actions aa

183: , pa.business_group_id
184: , bg.legislation_code
185: , lrl.rule_mode
186: from pay_payroll_actions pa
187: , pay_assignment_actions aa
188: , per_business_groups bg
189: , pay_legislation_rules lrl
190: where aa.assignment_action_id = p_assignment_action_id
191: and aa.payroll_action_id = pa.payroll_action_id

Line 200: , pay_assignment_actions aa

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

Line 253: , pay_assignment_actions aa

249: , rb.SOURCE_TEXT
250: , rb.SOURCE_NUMBER
251: , rb.SOURCE_TEXT2
252: from pay_run_balances rb
253: , pay_assignment_actions aa
254: , pay_payroll_actions pa
255: where rb.ASSIGNMENT_ID = l_assignment_id
256: and l_action_sequence >= aa.action_sequence
257: and rb.assignment_action_id = aa.assignment_action_id

Line 281: from pay_assignment_actions aa,

277: , decode(l_st2_needed_chr,
278: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
279: ,rr.run_result_id)
280: ,null) source_text2
281: from pay_assignment_actions aa,
282: pay_payroll_actions pa,
283: pay_run_results rr
284: where aa.ASSIGNMENT_ID = l_assignment_id
285: and aa.assignment_action_id = rr.assignment_action_id