APPS.PAY_FR_DB_PAY_SETUP dependencies on PAY_BALANCE_CATEGORIES_F

Line 1507: from pay_balance_categories_f cat

1503: )
1504: is
1505: select balance_category_id
1506: , business_group_id
1507: from pay_balance_categories_f cat
1508: where category_name = p_cat_name
1509: and nvl(legislation_code,'NULL') = nvl(p_cat_leg, 'NULL')
1510: and p_eff_date between cat.effective_start_date
1511: and cat.effective_end_date;

Line 1571: l_bal_cat_id pay_balance_categories_f.balance_category_id%type default null;

1567: v_uom varchar2(80);
1568: v_money VARCHAR2(80);
1569: v_rowid VARCHAR2(100);
1570: v_leg_code varchar2(30);
1571: l_bal_cat_id pay_balance_categories_f.balance_category_id%type default null;
1572: l_cat_bg pay_balance_categories_f.business_group_id%type;
1573: v_legislation_code varchar2(30);
1574: l_ctl_bg number;
1575: l_ctl_leg varchar2(30);

Line 1572: l_cat_bg pay_balance_categories_f.business_group_id%type;

1568: v_money VARCHAR2(80);
1569: v_rowid VARCHAR2(100);
1570: v_leg_code varchar2(30);
1571: l_bal_cat_id pay_balance_categories_f.balance_category_id%type default null;
1572: l_cat_bg pay_balance_categories_f.business_group_id%type;
1573: v_legislation_code varchar2(30);
1574: l_ctl_bg number;
1575: l_ctl_leg varchar2(30);
1576: l_bt_id pay_balance_types.balance_type_id%type;

Line 2105: l_bal_cat_id pay_balance_categories_f.balance_category_id%type;

2101: v_bt_balance_type_id number;
2102: v_bt_legislation_subgroup varchar2(30);
2103: v_bt_balance_category_id number;
2104: v_def_bal_nextval number;
2105: l_bal_cat_id pay_balance_categories_f.balance_category_id%type;
2106: l_run_bal_flag pay_defined_balances.save_run_balance%type;
2107: l_eff_date date;
2108: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
2109: v_dfb_legislation_code pay_defined_balances.legislation_code%type;