APPS.PAY_NZ_QES_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 291: p_balance_dimension in pay_balance_dimensions.database_item_suffix%type)

287: -- Suffix passed in.
288: ------------------------------------------------------------------------
289: function id_for_defined_balance
290: (p_balance_name in pay_balance_types.balance_name%type,
291: p_balance_dimension in pay_balance_dimensions.database_item_suffix%type)
292: return pay_balance_types.balance_type_id%type is
293:
294: v_balance_id pay_balance_types.balance_type_id%type;
295:

Line 298: c_balance_dimension pay_balance_dimensions.database_item_suffix%type) is

294: v_balance_id pay_balance_types.balance_type_id%type;
295:
296: cursor balance_id
297: (c_balance_name pay_balance_types.balance_name%type,
298: c_balance_dimension pay_balance_dimensions.database_item_suffix%type) is
299: select pdb.defined_balance_id
300: from pay_balance_dimensions pbd,
301: pay_defined_balances pdb,
302: pay_balance_types pbt

Line 300: from pay_balance_dimensions pbd,

296: cursor balance_id
297: (c_balance_name pay_balance_types.balance_name%type,
298: c_balance_dimension pay_balance_dimensions.database_item_suffix%type) is
299: select pdb.defined_balance_id
300: from pay_balance_dimensions pbd,
301: pay_defined_balances pdb,
302: pay_balance_types pbt
303: where pbt.balance_type_id = pdb.balance_type_id
304: and pbd.balance_dimension_id = pdb.balance_dimension_id