DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on GL_SETS_OF_BOOKS

Line 4716: FROM gl_sets_of_books

4712:
4713: --Fetch chart of accounts
4714: SELECT chart_of_accounts_id
4715: INTO l_chart_of_accounts_id
4716: FROM gl_sets_of_books
4717: WHERE set_of_books_id = p_set_of_books_id;
4718:
4719: IF (fnd_flex_keyval.validate_segs
4720: ('CREATE_COMB_NO_AT', --bugfix:3888581

Line 4887: FROM gl_sets_of_books

4883: p_invoice_rec.accts_pay_code_combination_id;
4884:
4885: SELECT chart_of_accounts_id
4886: INTO l_chart_of_accounts_id
4887: FROM gl_sets_of_books
4888: WHERE set_of_books_id = p_set_of_books_id;
4889:
4890: IF l_acct_type <> 'L' THEN
4891: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then

Line 15465: GL_SETS_OF_BOOKS gsob

15461:
15462: SELECT 'The period is NOT beyond latest encumbrance year'
15463: INTO l_DUMMY
15464: FROM GL_PERIOD_STATUSES gps1,
15465: GL_SETS_OF_BOOKS gsob
15466: WHERE gps1.period_year <= gsob.latest_encumbrance_year
15467: AND gsob.SET_OF_BOOKS_ID = p_set_of_books_id
15468: AND gps1.APPLICATION_ID = 200
15469: AND gps1.SET_OF_BOOKS_ID = gsob.SET_OF_BOOKS_ID