APPS.PAY_DEFINED_BALANCES_PKG dependencies on PAY_DEFINED_BALANCES_S

Line 175: l_save_run_bal_flag pay_defined_balances.save_run_balance%type;

171: and dim.dimension_type = 'R';
172: --
173: l_cat_flag pay_balance_categories_f.save_run_balance_enabled%type;
174: l_dim_flag pay_balance_dimensions.save_run_balance_enabled%type;
175: l_save_run_bal_flag pay_defined_balances.save_run_balance%type;
176: --
177: BEGIN
178: open get_cat_flag(p_balance_category_id, p_effective_date);
179: fetch get_cat_flag into l_cat_flag;

Line 401: CURSOR C2 IS SELECT pay_defined_balances_s.nextval FROM sys.dual;

397: --
398: CURSOR C IS SELECT rowid FROM pay_defined_balances
399: WHERE defined_balance_id = X_Defined_Balance_Id;
400: --
401: CURSOR C2 IS SELECT pay_defined_balances_s.nextval FROM sys.dual;
402: --
403: CURSOR C3 IS SELECT count(*) from pay_defined_balances
404: WHERE Balance_Type_Id = X_Balance_Type_Id
405: AND Grossup_Allowed_Flag = 'Y';

Line 420: l_save_run_bal_flag pay_defined_balances.save_run_balance%type;

416: from fnd_sessions
417: where session_id = userenv('sessionid');
418: --
419: l_exists number ;
420: l_save_run_bal_flag pay_defined_balances.save_run_balance%type;
421: l_bal_cat_id pay_balance_categories_f.balance_category_id%type;
422: l_eff_date date;
423: --
424: BEGIN