APPS.PAY_NZ_QES_PKG dependencies on PAY_BALANCE_TYPES

Line 290: (p_balance_name in pay_balance_types.balance_name%type,

286: -- Returns the Defined Balance Id for the Balance Name and Database Item
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;

Line 292: return pay_balance_types.balance_type_id%type is

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:
296: cursor balance_id

Line 294: v_balance_id pay_balance_types.balance_type_id%type;

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:
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

Line 297: (c_balance_name pay_balance_types.balance_name%type,

293:
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,

Line 302: pay_balance_types pbt

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
305: and pbt.balance_name = c_balance_name
306: and pbd.database_item_suffix = c_balance_dimension;