APPS.PAY_DB_PAY_SETUP dependencies on PAY_BALANCE_CATEGORIES_F

Line 1509: from pay_balance_categories_f cat

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

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

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

Line 1574: l_cat_bg pay_balance_categories_f.business_group_id%type;

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

Line 2098: l_bal_cat_id pay_balance_categories_f.balance_category_id%type;

2094: v_bt_balance_type_id number;
2095: v_bt_legislation_subgroup varchar2(30);
2096: v_bt_balance_category_id number;
2097: v_def_bal_nextval number;
2098: l_bal_cat_id pay_balance_categories_f.balance_category_id%type;
2099: l_run_bal_flag pay_defined_balances.save_run_balance%type;
2100: l_eff_date date;
2101: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
2102: v_dfb_legislation_code pay_defined_balances.legislation_code%type;