353: CURSOR deprn_expense_cur IS
354: SELECT 1
355: FROM gl_code_combinations gcc,
356: gl_sets_of_books gsob,
357: pa_implementations pi
358: WHERE gcc.code_combination_id = l_deprn_expense_ccid
359: AND gcc.chart_of_accounts_id = gsob.chart_of_accounts_id
360: AND gsob.set_of_books_id = pi.set_of_books_id
361: AND gcc.account_type = 'E';
490: SELECT 'Y'
491: INTO X_CCID_VALID
492: FROM gl_code_combinations gcc,
493: gl_sets_of_books gsob,
494: pa_implementations pi
495: WHERE gcc.code_combination_id = p_ccid
496: AND gcc.chart_of_accounts_id = gsob.chart_of_accounts_id
497: AND gsob.set_of_books_id = pi.set_of_books_id
498: AND gcc.account_type = 'E';