APPS.PAY_IN_BAL_UPL_STRUCT dependencies on PER_BUSINESS_GROUPS

Line 298: l_bg_id per_business_groups.business_group_id%TYPE;

294: */
295:
296: retcode number := 0;
297: i number := 0;
298: l_bg_id per_business_groups.business_group_id%TYPE;
299: l_leg_code per_business_groups.legislation_code%TYPE;
300: l_bt_id pay_balance_types.balance_type_id%TYPE;
301: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
302: l_procedure VARCHAR2(100);

Line 299: l_leg_code per_business_groups.legislation_code%TYPE;

295:
296: retcode number := 0;
297: i number := 0;
298: l_bg_id per_business_groups.business_group_id%TYPE;
299: l_leg_code per_business_groups.legislation_code%TYPE;
300: l_bt_id pay_balance_types.balance_type_id%TYPE;
301: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
302: l_procedure VARCHAR2(100);
303: l_message VARCHAR2(255);

Line 308: from per_business_groups hou,

304:
305: CURSOR csr_bg IS
306: select hou.business_group_id,
307: hou.legislation_code
308: from per_business_groups hou,
309: pay_balance_batch_headers bbh
310: where bbh.batch_id = p_batch_id
311: and upper(hou.name) = upper(bbh.business_group_name);
312:

Line 397: l_currency_code per_business_groups.currency_code%TYPE;

393: l_jur_count number;
394: l_bal_count number;
395: l_no_bal_for_jur number;
396: l_dummy_id number;
397: l_currency_code per_business_groups.currency_code%TYPE;
398: l_source_iv number(2) := 0;
399: l_source_iv_val VARCHAR2(30);
400: l_jur_iv number(2) := 0;
401: l_jur_iv_val VARCHAR2(30);

Line 434: ,per_business_groups pbg

430: ,bbh.business_group_name
431: ,pbg.currency_code
432: ,pbg.legislation_code
433: FROM pay_balance_batch_headers bbh
434: ,per_business_groups pbg
435: WHERE batch_id = p_batch_id
436: AND upper(pbg.name) = upper(bbh.business_group_name);
437:
438: CURSOR csr_rule1 (p_leg_code IN VARCHAR2)