APPS.PAY_IP_BAL_UPL_STRUCT dependencies on PER_BUSINESS_GROUPS

Line 229: l_bg_id per_business_groups.business_group_id%TYPE;

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

Line 230: l_leg_code per_business_groups.legislation_code%TYPE;

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

Line 247: from per_business_groups hou,

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

Line 328: per_business_groups pbg

324: pbg.currency_code, pbg.legislation_code
325: into l_bg_id, l_bg_name,
326: l_currency_code, l_leg_code
327: from pay_balance_batch_headers bbh,
328: per_business_groups pbg
329: where batch_id = p_batch_id
330: and upper(pbg.name) = upper(bbh.business_group_name);
331:
332: retcode := validate_batch_data (p_batch_id);