APPS.PAYBALUP dependencies on PER_BUSINESS_GROUPS

Line 279: l_bg_id per_business_groups.business_group_id%TYPE;

275: */
276: --
277: retcode number := 0;
278: i number := 0;
279: l_bg_id per_business_groups.business_group_id%TYPE;
280: l_leg_code per_business_groups.legislation_code%TYPE;
281: l_bt_id pay_balance_types.balance_type_id%TYPE;
282: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
283: --

Line 280: l_leg_code per_business_groups.legislation_code%TYPE;

276: --
277: retcode number := 0;
278: i number := 0;
279: l_bg_id per_business_groups.business_group_id%TYPE;
280: l_leg_code per_business_groups.legislation_code%TYPE;
281: l_bt_id pay_balance_types.balance_type_id%TYPE;
282: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
283: --
284: cursor c_each_batch (c_batch_id number) is

Line 297: from per_business_groups hou,

293: select hou.business_group_id,
294: hou.legislation_code
295: into l_bg_id,
296: l_leg_code
297: from per_business_groups hou,
298: pay_balance_batch_headers bbh
299: where bbh.batch_id = p_batch_id
300: and upper(hou.name) = upper(bbh.business_group_name);
301: EXCEPTION WHEN no_data_found THEN

Line 377: per_business_groups pbg

373: pbg.currency_code
374: into l_bg_id, l_bg_name,
375: l_currency_code
376: from pay_balance_batch_headers bbh,
377: per_business_groups pbg
378: where batch_id = p_batch_id
379: and upper(pbg.name) = upper(bbh.business_group_name);
380: --
381: retcode := validate_batch_data (p_batch_id);