APPS.FA_CUA_MASS_EXT_RET_PKG dependencies on FA_LOOKUPS

Line 342: from fa_lookups

338:
339:
340: Cursor c_ret_type IS
341: select 'Y'
342: from fa_lookups
343: where lookup_type = 'RETIREMENT'
344: and enabled_flag = 'Y'
345: and nvl(end_date_active,sysdate+1) > sysdate
346: and lookup_code = G_retirement_type_code;