DBA Data[Home] [Help]

APPS.PAY_FR_DB_PAY_SETUP dependencies on PAY_DEFINED_BALANCES_S

Line 2106: l_run_bal_flag pay_defined_balances.save_run_balance%type;

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;
2110: v_dfb_legislation_subgroup pay_defined_balances.legislation_subgroup%type;

Line 2200: select pay_defined_balances_s.nextval

2196: -- Bug 2646924 - changed p_legislation_code to v_legislation_code in the
2197: -- where clause, to enabled user defined_balances to be created for
2198: -- startup balances.
2199: --
2200: select pay_defined_balances_s.nextval
2201: , bt.business_group_id
2202: , bt.legislation_code
2203: , bt.balance_type_id
2204: , bt.legislation_subgroup