APPS.FA_RETIREMENT_PUB dependencies on FA_LOOKUPS_B

Line 2027: -- changed fa_lookups to fa_lookups_b for high-cost sql fix

2023: p_asset_id number;
2024: p_dpis date;
2025:
2026:
2027: -- changed fa_lookups to fa_lookups_b for high-cost sql fix
2028: CURSOR bk_cursor IS
2029: select bk.transaction_header_id_in
2030: ,bk.Allowed_Deprn_Limit_Amount
2031: ,bk.date_effective

Line 2038: ,fa_lookups_b lk

2034: ,lk.lookup_type
2035: from fa_books bk
2036: ,fa_itc_rates itc
2037: ,fa_ceilings ce
2038: ,fa_lookups_b lk
2039: where bk.asset_id = p_asset_id
2040: and bk.book_type_code = p_book_type_code
2041: and bk.date_ineffective is null
2042: and bk.itc_amount_id = itc.itc_amount_id(+)

Line 2059: ,fa_lookups_b lk

2055: ,lk.lookup_type
2056: from fa_mc_books bk
2057: ,fa_itc_rates itc
2058: ,fa_ceilings ce
2059: ,fa_lookups_b lk
2060: where bk.asset_id = p_asset_id
2061: and bk.book_type_code = p_book_type_code
2062: and bk.date_ineffective is null
2063: and bk.itc_amount_id = itc.itc_amount_id(+)