DBA Data[Home] [Help]

APPS.PA_CAPITAL_PROJECT_UTILS dependencies on GL_SETS_OF_BOOKS

Line 356: gl_sets_of_books gsob,

352: --Used to determine if the Depreciation Expense CCID is valid for the current COA
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

Line 493: gl_sets_of_books gsob,

489: --Dbms_Output.Put_Line('select');
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