APPS.PAY_US_W2_BOX_BAL dependencies on PAY_BALANCE_TYPES

Line 67: FROM pay_balance_types

63: /* Cursor to determine balance type id */
64:
65: CURSOR csr_balance_id(cp_balance_name VARCHAR2) IS
66: ( SELECT balance_type_id
67: FROM pay_balance_types
68: WHERE balance_name = cp_balance_name
69: AND business_group_id = p_business_group_id);
70:
71: CURSOR c_get_lookup_code(cp_lookup_type in varchar2,

Line 242: UPDATE pay_balance_types

238: to_char(ln_bal_type_id));
239: plog('Updating the Balance Category: '||lv_balance||' '||
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' )