APPS.PAY_AU_SGC_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 73: pay_balance_dimensions pbd,

69: c_legislation_code pay_balance_types.legislation_code%type)
70: is
71: select pdb.defined_balance_id
72: FROM pay_balance_types pbt,
73: pay_balance_dimensions pbd,
74: pay_defined_balances pdb
75: where pbt.balance_type_id=c_balance_type_id
76: AND nvl(pbt.legislation_code,'AU')=c_legislation_code
77: AND pbd.database_item_suffix = '_ASG_LE_MTD'

Line 89: pay_balance_dimensions pbd,

85: c_legislation_code pay_balance_types.legislation_code%type)
86: is
87: select pdb.defined_balance_id
88: FROM pay_balance_types pbt,
89: pay_balance_dimensions pbd,
90: pay_defined_balances pdb
91: where pbt.balance_type_id=c_balance_type_id
92: AND nvl(pbt.legislation_code,'AU')=c_legislation_code
93: AND pbd.database_item_suffix = '_ASG_LE_QTD'