APPS.PAY_US_W2_BOX_BAL dependencies on PAY_BALANCE_CATEGORIES_F

Line 223: FROM PAY_BALANCE_CATEGORIES_F

219: ************************************************************/
220:
221:
222: SELECT CATEGORY_NAME,EFFECTIVE_START_DATE into lv_category,l_start_date
223: FROM PAY_BALANCE_CATEGORIES_F
224: WHERE LEGISLATION_CODE = 'US'
225: AND CATEGORY_NAME = 'Information';
226:
227: ln_bal_type_id := Pay_DB_Pay_Setup.Create_Balance_type(

Line 244: FROM PAY_BALANCE_CATEGORIES_F

240: to_char(ln_bal_type_id));
241:
242: UPDATE pay_balance_types
243: SET BALANCE_CATEGORY_ID = ( SELECT BALANCE_CATEGORY_ID
244: FROM PAY_BALANCE_CATEGORIES_F
245: WHERE LEGISLATION_CODE = 'US'
246: AND CATEGORY_NAME = 'Information' )
247: WHERE balance_type_id = ln_bal_type_id;
248: