230: )is
231: select defined_balance_id
232: from pay_defined_balances pdb
233: , pay_balance_types pbt
234: , pay_balance_dimensions dim
235: where pdb.balance_type_id = pbt.balance_type_id
236: and pdb.balance_dimension_id = dim.balance_dimension_id
237: and pbt.balance_name = p_balance_name
238: and dim.dimension_name = p_dimension_name
346: )is
347: select defined_balance_id
348: from pay_defined_balances pdb
349: , pay_balance_types pbt
350: , pay_balance_dimensions dim
351: where pdb.balance_type_id = pbt.balance_type_id
352: and pdb.balance_dimension_id = dim.balance_dimension_id
353: and pbt.balance_name = p_balance_name
354: and dim.dimension_name = p_dimension_name