APPS.PAY_CN_BAL_UPL_STRUCT dependencies on PER_BUSINESS_GROUPS

Line 365: l_bg_id per_business_groups.business_group_id%TYPE;

361: IS
362:
363: retcode NUMBER := 0;
364: i NUMBER := 0;
365: l_bg_id per_business_groups.business_group_id%TYPE;
366: l_leg_code per_business_groups.legislation_code%TYPE;
367: l_bt_id pay_balance_types.balance_type_id%TYPE;
368: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
369: --

Line 366: l_leg_code per_business_groups.legislation_code%TYPE;

362:
363: retcode NUMBER := 0;
364: i NUMBER := 0;
365: l_bg_id per_business_groups.business_group_id%TYPE;
366: l_leg_code per_business_groups.legislation_code%TYPE;
367: l_bt_id pay_balance_types.balance_type_id%TYPE;
368: l_bal_dim_id pay_balance_dimensions.balance_dimension_id%TYPE;
369: --
370: CURSOR csr_bg IS

Line 373: FROM per_business_groups hou,

369: --
370: CURSOR csr_bg IS
371: SELECT hou.business_group_id,
372: hou.legislation_code
373: FROM per_business_groups hou,
374: pay_balance_batch_headers bbh
375: WHERE bbh.batch_id = p_batch_id
376: AND upper(hou.name) = upper(bbh.business_group_name);
377: --

Line 477: l_currency_code per_business_groups.currency_code%TYPE;

473: l_jur_count NUMBER;
474: l_bal_count NUMBER;
475: l_no_bal_for_jur NUMBER;
476: l_dummy_id NUMBER;
477: l_currency_code per_business_groups.currency_code%TYPE;
478: l_source_iv NUMBER(2) := 0;
479: l_source_iv_val pay_legislation_rules.rule_mode%TYPE;
480: l_source_text_iv NUMBER(2) := 0;
481: l_source_text_iv_val pay_legislation_rules.rule_mode%TYPE;

Line 521: ,per_business_groups pbg

517: ,bbh.business_group_name
518: ,pbg.currency_code
519: ,pbg.legislation_code
520: FROM pay_balance_batch_headers bbh
521: ,per_business_groups pbg
522: WHERE batch_id = p_batch_id
523: AND upper(pbg.name) = upper(bbh.business_group_name);
524:
525: CURSOR csr_rule1 (p_leg_code IN VARCHAR2)