APPS.PYSGBUPL dependencies on PER_BUSINESS_GROUPS

Line 228: l_bg_id per_business_groups.business_group_id%TYPE;

224: */
225: --
226: retcode number := 0;
227: i number := 0;
228: l_bg_id per_business_groups.business_group_id%TYPE;
229: l_leg_code per_business_groups.legislation_code%TYPE;
230: l_bt_id pay_balance_types.balance_type_id%TYPE;
231: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
232: --

Line 229: l_leg_code per_business_groups.legislation_code%TYPE;

225: --
226: retcode number := 0;
227: i number := 0;
228: l_bg_id per_business_groups.business_group_id%TYPE;
229: l_leg_code per_business_groups.legislation_code%TYPE;
230: l_bt_id pay_balance_types.balance_type_id%TYPE;
231: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
232: --
233: cursor c_each_batch (c_batch_id number) is

Line 246: from per_business_groups hou,

242: select hou.business_group_id,
243: hou.legislation_code
244: into l_bg_id,
245: l_leg_code
246: from per_business_groups hou,
247: pay_balance_batch_headers bbh
248: where bbh.batch_id = p_batch_id
249: and upper(hou.name) = upper(bbh.business_group_name);
250: EXCEPTION WHEN no_data_found THEN

Line 320: per_business_groups pbg

316: --
317: select pbg.business_group_id, bbh.business_group_name, pbg.currency_code
318: into l_bg_id, l_bg_name, l_bg_currency_code
319: from pay_balance_batch_headers bbh,
320: per_business_groups pbg
321: where batch_id = p_batch_id
322: and upper(pbg.name) = upper(bbh.business_group_name);
323: --
324: retcode := validate_batch_data (p_batch_id);