DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on GL_SETS_OF_BOOKS

Line 5047: FROM gl_sets_of_books

5043:
5044: --Fetch chart of accounts
5045: SELECT chart_of_accounts_id
5046: INTO l_chart_of_accounts_id
5047: FROM gl_sets_of_books
5048: WHERE set_of_books_id = p_set_of_books_id;
5049:
5050: IF (fnd_flex_keyval.validate_segs
5051: ('CREATE_COMB_NO_AT', --bugfix:3888581

Line 5218: FROM gl_sets_of_books

5214: p_invoice_rec.accts_pay_code_combination_id;
5215:
5216: SELECT chart_of_accounts_id
5217: INTO l_chart_of_accounts_id
5218: FROM gl_sets_of_books
5219: WHERE set_of_books_id = p_set_of_books_id;
5220:
5221: IF l_acct_type <> 'L' THEN
5222: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then

Line 16872: GL_SETS_OF_BOOKS gsob

16868:
16869: SELECT 'The period is NOT beyond latest encumbrance year'
16870: INTO l_DUMMY
16871: FROM GL_PERIOD_STATUSES gps1,
16872: GL_SETS_OF_BOOKS gsob
16873: WHERE gps1.period_year <= gsob.latest_encumbrance_year
16874: AND gsob.SET_OF_BOOKS_ID = p_set_of_books_id
16875: AND gps1.APPLICATION_ID = 200
16876: AND gps1.SET_OF_BOOKS_ID = gsob.SET_OF_BOOKS_ID