APPS.AP_RECURRING_INVOICES_PKG dependencies on FA_BOOK_CONTROLS

Line 879: FROM fa_book_controls bc

875: 'information IF possible';
876: BEGIN
877: SELECT count(*)
878: INTO c_asset_book_count
879: FROM fa_book_controls bc
880: WHERE bc.book_class = 'CORPORATE'
881: AND bc.set_of_books_id = P_set_of_books_id
882: AND bc.date_ineffective is null;
883:

Line 887: FROM fa_book_controls bc

883:
884: IF (C_asset_book_count = 1) then
885: SELECT bc.book_type_code
886: INTO P_asset_bt_code
887: FROM fa_book_controls bc
888: WHERE bc.set_of_books_id = P_set_of_books_id
889: AND bc.date_ineffective is null;
890:
891: ELSE

Line 2524: FROM fa_book_controls bc

2520: BEGIN
2521: debug_info := 'Get Asset Book count';
2522: SELECT count(*)
2523: INTO l_asset_book_count
2524: FROM fa_book_controls bc
2525: WHERE bc.book_class = 'CORPORATE'
2526: AND bc.set_of_books_id = p_set_of_books_id
2527: AND bc.date_ineffective is null;
2528:

Line 2532: FROM fa_book_controls bc

2528:
2529: IF (l_asset_book_count = 1) then
2530: SELECT bc.book_type_code
2531: INTO l_inv_line_asset_bt_code
2532: FROM fa_book_controls bc
2533: WHERE bc.set_of_books_id = p_set_of_books_id
2534: AND bc.date_ineffective is null;
2535:
2536: ELSE