DBA Data[Home] [Help]

APPS.PAY_ES_ONLINE_SOE dependencies on PER_BUSINESS_GROUPS

Line 136: , per_business_groups bg

132: , bg.legislation_code
133: , lrl.rule_mode
134: FROM pay_payroll_actions pa
135: , pay_assignment_actions aa
136: , per_business_groups bg
137: , pay_legislation_rules lrl
138: WHERE aa.assignment_action_id = p_assignment_action_id
139: AND aa.payroll_action_id = pa.payroll_action_id
140: AND pa.business_group_id = bg.business_group_id

Line 148: , per_business_groups bg

144: CURSOR getParameters(c_assignment_action_id IN NUMBER) IS
145: SELECT '''' || bg.currency_code || '''' currency_code
146: FROM pay_payroll_actions pa
147: , pay_assignment_actions aa
148: , per_business_groups bg
149: WHERE aa.assignment_action_id = p_assignment_action_id
150: AND aa.payroll_action_id = pa.payroll_action_id
151: AND pa.business_group_id = bg.business_group_id
152: AND rownum = 1;