DBA Data[Home] [Help]

APPS.PAY_SA_SOE dependencies on PER_BUSINESS_GROUPS

Line 191: , per_business_groups bg

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
194: and aa.payroll_action_id = pa.payroll_action_id
195: and pa.business_group_id = bg.business_group_id

Line 204: , per_business_groups bg

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
207: and pa.business_group_id = bg.business_group_id
208: and rownum = 1;