DBA Data[Home] [Help]

APPS.PAY_SA_SOE dependencies on PER_BUSINESS_GROUPS

Line 188: , per_business_groups bg

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
192: and pa.business_group_id = bg.business_group_id

Line 201: , per_business_groups bg

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
205: and rownum = 1;