967: cursor c_defined_bal_id ( p_balance_name in varchar2,
968: p_dimension_name in varchar2 )
969: is
970: select pdb.defined_balance_id
971: from pay_defined_balances pdb,
972: pay_balance_types pbt,
973: pay_balance_dimensions pbd
974: where pbt.balance_name = p_balance_name
975: and pbd.dimension_name = p_dimension_name
1152: cursor c_defined_bal_id ( p_balance_name in varchar2,
1153: p_dimension_name in varchar2 )
1154: is
1155: select pdb.defined_balance_id
1156: from pay_defined_balances pdb,
1157: pay_balance_types pbt,
1158: pay_balance_dimensions pbd
1159: where pbt.balance_name = p_balance_name
1160: and pbd.dimension_name = p_dimension_name