APPS.PAY_AU_SGC_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 53: c_dimension_name pay_balance_dimensions.database_item_suffix%type)

49:
50: /*Bug 2610141----Modfied the cursor to return defined_balanace_id */
51:
52: cursor c_super_bal_id(c_legislation_code pay_balance_types.legislation_code%type,
53: c_dimension_name pay_balance_dimensions.database_item_suffix%type)
54: is
55: select pdb.defined_balance_id
56: FROM pay_balance_types pbt,
57: pay_balance_dimensions pbd,

Line 57: pay_balance_dimensions pbd,

53: c_dimension_name pay_balance_dimensions.database_item_suffix%type)
54: is
55: select pdb.defined_balance_id
56: FROM pay_balance_types pbt,
57: pay_balance_dimensions pbd,
58: pay_defined_balances pdb
59: where pbt.balance_name='Super_Guarantee'
60: AND pbt.legislation_code=c_legislation_code
61: AND pbd.database_item_suffix = c_dimension_name