DBA Data[Home] [Help]

APPS.PAY_US_USERRA dependencies on PAY_DEFINED_BALANCES

Line 242: FROM pay_defined_balances db,

238: hr_utility.trace('lv_dimension ='||lv_dimension);
239:
240: SELECT count(0)
241: INTO ln_exists
242: FROM pay_defined_balances db,
243: pay_balance_dimensions dim
244: WHERE db.balance_type_id = ln_bal_type_id
245: AND db.balance_dimension_id = dim.balance_dimension_id
246: AND dim.dimension_name = lv_dimension;