APPS.FA_TOFES_YUD_ALEF_PKG dependencies on FA_BOOKS

Line 84: FROM FA_BOOKS FB

80: SELECT CASE WHEN (MONTHS_BETWEEN(ADD_MONTHS(FB.DATE_PLACED_IN_SERVICE,FB.LIFE_IN_MONTHS), FDP.PERIOD_OPEN_DATE)) > 12 THEN 12
81: ELSE (MONTHS_BETWEEN(ADD_MONTHS(FB.DATE_PLACED_IN_SERVICE,FB.LIFE_IN_MONTHS), FDP.PERIOD_OPEN_DATE))
82: END
83: INTO ln_number
84: FROM FA_BOOKS FB
85: ,FA_DEPRN_PERIODS FDP
86: WHERE FB.BOOK_type_code = FDP.book_type_code
87: AND FB.BOOK_type_code = P_BOOK_NAME
88: AND FDP.period_counter = p_lex_begin_period_counter

Line 91: FROM FA_BOOKS fb1

87: AND FB.BOOK_type_code = P_BOOK_NAME
88: AND FDP.period_counter = p_lex_begin_period_counter
89: AND FB.DEPRECIATE_FLAG = 'YES'
90: AND FB.TRANSACTION_HEADER_ID_IN = (SELECT max(fb1.TRANSACTION_HEADER_ID_IN)
91: FROM FA_BOOKS fb1
92: WHERE fb1.BOOK_type_code = P_BOOK_NAME
93: AND fb1.DEPRECIATE_FLAG = 'YES');
94: RETURN ln_number;
95: EXCEPTION

Line 231: ,FA_BOOKS FB

227: FROM AP_INVOICES_ALL
228: WHERE INVOICE_ID IN (SELECT FAI.INVOICE_ID
229: FROM FA_ASSET_INVOICES FAI
230: ,FA_ADDITIONS_B FA
231: ,FA_BOOKS FB
232: WHERE FAI.ASSET_ID = FA.ASSET_ID
233: AND FA.ASSET_ID = FB.ASSET_ID
234: AND FA.ASSET_ID = p_asset_id_in
235: AND FB.BOOK_TYPE_CODE = P_BOOK_NAME)

Line 239: ,FA_BOOKS FB

235: AND FB.BOOK_TYPE_CODE = P_BOOK_NAME)
236: AND VENDOR_ID IN (SELECT FAI.PO_VENDOR_ID
237: FROM FA_ASSET_INVOICES FAI
238: ,FA_ADDITIONS_B FA
239: ,FA_BOOKS FB
240: WHERE FAI.ASSET_ID = FA.ASSET_ID
241: AND FA.ASSET_ID = FB.ASSET_ID
242: AND FA.ASSET_ID = p_asset_id_in
243: AND FB.BOOK_TYPE_CODE = P_BOOK_NAME);

Line 251: ,FA_BOOKS FB

247: WHEN NO_DATA_FOUND THEN
248: SELECT FB.DATE_PLACED_IN_SERVICE
249: INTO ld_date
250: FROM FA_ADDITIONS_B FA
251: ,FA_BOOKS FB
252: WHERE FA.ASSET_ID = FB.ASSET_ID
253: AND FA.ASSET_ID = p_asset_id_in
254: AND FB.BOOK_TYPE_CODE = P_BOOK_NAME
255: AND FB.TRANSACTION_HEADER_ID_OUT IS NULL;