APPS.FA_FASCOSTD_XMLP_PKG dependencies on FA_LOOKUPS_B

Line 2291: FA_LOOKUPS_B RT,

2287: 'RESERVE', DD.Deprn_Amount - decode(ADJ.debit_credit_flag,'DR',1,-1)
2288: * nvl(ADJ.adjustment_amount,0),
2289: 'REVAL RESERVE', -DD.Reval_Amortization))
2290: FROM
2291: FA_LOOKUPS_B RT,
2292: FA_CATEGORY_BOOKS CB,
2293: FA_DISTRIBUTION_HISTORY DH,
2294: FA_ASSET_HISTORY AH,
2295: FA_DEPRN_DETAIL_MRC_V DD,

Line 2370: FA_LOOKUPS_B RT,

2366: 'RESERVE', DD.Deprn_Amount - decode(ADJ.debit_credit_flag,'DR',1,-1)
2367: * nvl(ADJ.adjustment_amount,0),
2368: 'REVAL RESERVE', -DD.Reval_Amortization))
2369: FROM
2370: FA_LOOKUPS_B RT,
2371: FA_CATEGORY_BOOKS CB,
2372: FA_DISTRIBUTION_HISTORY DH,
2373: FA_ASSET_HISTORY AH,
2374: FA_DEPRN_DETAIL DD,

Line 2616: FA_LOOKUPS table has been split into two tables: FA_LOOKUPS_B and

2612:
2613: /* DELETE FROM FA_BALANCES_REPORT_GT; */
2614:
2615: /*This section of code needs to be replaced due to the fact that in 11.5 the
2616: FA_LOOKUPS table has been split into two tables: FA_LOOKUPS_B and
2617: FA_LOOKUPS_TL . FA_LOOKUPS is a synonym for a view of a join of these two
2618: tables. So Inserts and Deletes wont work on FA_LOOKUPS, and instead must be
2619: performed on both tables. Changes made by cbachand, 5/25/99
2620: DELETE FROM FA_LOOKUPS

Line 2639: DELETE FROM FA_LOOKUPS_B

2635: Report_Type,
2636: 'Y'); */
2637:
2638:
2639: DELETE FROM FA_LOOKUPS_B
2640: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2641: AND LOOKUP_CODE = Report_Type;
2642:
2643:

Line 2648: INSERT INTO FA_LOOKUPS_B

2644: DELETE FROM FA_LOOKUPS_TL
2645: WHERE LOOKUP_TYPE = 'REPORT TYPE'
2646: AND LOOKUP_CODE = Report_Type;
2647:
2648: INSERT INTO FA_LOOKUPS_B
2649: (LOOKUP_TYPE,
2650: LOOKUP_CODE,
2651: LAST_UPDATED_BY,
2652: LAST_UPDATE_DATE,