DBA Data[Home] [Help]

APPS.AP_IMPORT_INVOICES_PKG dependencies on FA_BOOK_CONTROLS

Line 615: l_asset_book_type FA_BOOK_CONTROLS.book_type_code%TYPE;

611: -- Bug 5448579
612: l_moac_org_table AP_IMPORT_INVOICES_PKG.moac_ou_tab_type;
613: l_fsp_org_table AP_IMPORT_INVOICES_PKG.fsp_org_tab_type;
614: l_index_org_id NUMBER;
615: l_asset_book_type FA_BOOK_CONTROLS.book_type_code%TYPE;
616:
617: -- Bug 5645581.
618: l_inv_gl_date DATE; --Bug 5382889. LE Timezone
619: l_rts_txn_le_date DATE; --Bug 5382889. LE Timezone

Line 5269: FROM fa_book_controls bc

5265: END IF;
5266: BEGIN
5267: SELECT count(*)
5268: INTO l_asset_book_count
5269: FROM fa_book_controls bc
5270: WHERE bc.book_class = 'CORPORATE'
5271: AND bc.set_of_books_id = p_set_of_books_id
5272: AND bc.date_ineffective IS NULL;
5273:

Line 5277: FROM fa_book_controls bc

5273:
5274: IF (l_asset_book_count = 1) THEN
5275: SELECT bc.book_type_code
5276: INTO p_asset_book_type
5277: FROM fa_book_controls bc
5278: WHERE bc.book_class = 'CORPORATE' --bug6847888
5279: AND bc.set_of_books_id = p_set_of_books_id
5280: AND bc.date_ineffective IS NULL;
5281: