APPS.PAY_DEFINED_BALANCES_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 149: -- pay_balance_categories_f and pay_balance_dimensions.

145: -----------------------------------------------------------------------------
146: -- function set_save_run_bals_flag
147: -- Description - sets the value of save_run_balance on pay_defined_balances,
148: -- the value is determined by the values of save_run_balance_enabled on
149: -- pay_balance_categories_f and pay_balance_dimensions.
150: -----------------------------------------------------------------------------
151: function set_save_run_bals_flag(p_balance_category_id number
152: ,p_effective_date date
153: ,p_balance_dimension_id number)

Line 169: from pay_balance_dimensions dim

165: --
166: cursor get_dim_flag(p_dim_id number)
167: is
168: select dim.save_run_balance_enabled
169: from pay_balance_dimensions dim
170: where dim.balance_dimension_id = p_dim_id
171: and dim.dimension_type = 'R';
172: --
173: l_cat_flag pay_balance_categories_f.save_run_balance_enabled%type;

Line 174: l_dim_flag pay_balance_dimensions.save_run_balance_enabled%type;

170: where dim.balance_dimension_id = p_dim_id
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);