APPS.FA_MASS_REC_UTILS_PKG dependencies on FA_LOOKUPS

Line 142: FROM fa_lookups

138: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
139: -- cursor to fetch the meaning for depreciate flag.
140: CURSOR get_deprn_flag IS
141: SELECT nvl(meaning, X_Asset_Rec.depreciate_flag)
142: FROM fa_lookups
143: WHERE lookup_code = X_Asset_Rec.depreciate_flag
144: AND lookup_type = 'YESNO';
145: h_deprn_flag_mean VARCHAR2(80);
146: BEGIN

Line 346: FROM fa_lookups

342: h_fully_rsvd VARCHAR2(3) := NULL;
343: -- cursors to get meanings for asset type and fully reserved flag.
344: CURSOR get_asset_type_mean IS
345: SELECT nvl(meaning, h_asset_type)
346: FROM fa_lookups
347: WHERE lookup_code = h_asset_type
348: AND lookup_type = 'ASSET TYPE';
349: CURSOR get_fully_rsvd_mean IS
350: SELECT nvl(meaning, h_fully_rsvd)

Line 351: FROM fa_lookups

347: WHERE lookup_code = h_asset_type
348: AND lookup_type = 'ASSET TYPE';
349: CURSOR get_fully_rsvd_mean IS
350: SELECT nvl(meaning, h_fully_rsvd)
351: FROM fa_lookups
352: WHERE lookup_code = h_fully_rsvd
353: AND lookup_type = 'YESNO';
354:
355: delim VARCHAR2(1);