DBA Data[Home] [Help]

APPS.PAY_DB_PAY_SETUP dependencies on PAY_DEFINED_BALANCES_S

Line 2122: l_run_bal_flag pay_defined_balances.save_run_balance%type;

2118: v_bt_legislation_subgroup varchar2(30);
2119: v_bt_balance_category_id number;
2120: v_def_bal_nextval number;
2121: l_bal_cat_id pay_balance_categories_f.balance_category_id%type;
2122: l_run_bal_flag pay_defined_balances.save_run_balance%type;
2123: l_eff_date date;
2124: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
2125: v_dfb_legislation_code pay_defined_balances.legislation_code%type;
2126: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;

Line 2216: select pay_defined_balances_s.nextval

2212: -- Bug 2646924 - changed p_legislation_code to v_legislation_code in the
2213: -- where clause, to enabled user defined_balances to be created for
2214: -- startup balances.
2215: --
2216: select pay_defined_balances_s.nextval
2217: , bt.business_group_id
2218: , bt.legislation_code
2219: , bt.balance_type_id
2220: , bt.legislation_subgroup