APPS.AP_RECURRING_INVOICES_PKG dependencies on FA_BOOK_CONTROLS

Line 855: FROM fa_book_controls bc

851: 'information IF possible';
852: BEGIN
853: SELECT count(*)
854: INTO c_asset_book_count
855: FROM fa_book_controls bc
856: WHERE bc.book_class = 'CORPORATE'
857: AND bc.set_of_books_id = P_set_of_books_id
858: AND bc.date_ineffective is null;
859:

Line 863: FROM fa_book_controls bc

859:
860: IF (C_asset_book_count = 1) then
861: SELECT bc.book_type_code
862: INTO P_asset_bt_code
863: FROM fa_book_controls bc
864: WHERE bc.set_of_books_id = P_set_of_books_id
865: AND bc.date_ineffective is null;
866:
867: ELSE

Line 2491: FROM fa_book_controls bc

2487: BEGIN
2488: debug_info := 'Get Asset Book count';
2489: SELECT count(*)
2490: INTO l_asset_book_count
2491: FROM fa_book_controls bc
2492: WHERE bc.book_class = 'CORPORATE'
2493: AND bc.set_of_books_id = p_set_of_books_id
2494: AND bc.date_ineffective is null;
2495:

Line 2499: FROM fa_book_controls bc

2495:
2496: IF (l_asset_book_count = 1) then
2497: SELECT bc.book_type_code
2498: INTO l_inv_line_asset_bt_code
2499: FROM fa_book_controls bc
2500: WHERE bc.set_of_books_id = p_set_of_books_id
2501: AND bc.date_ineffective is null;
2502:
2503: ELSE