DBA Data[Home] [Help]

APPS.FA_MASSTFR_PKG dependencies on FA_ASSET_HIERARCHY

Line 162: from FA_ASSET_HIERARCHY ASH

158: gcc.segment29 BETWEEN nvl(mtfr_rec.segment29_Low,gcc.segment29) AND nvl(mtfr_rec.segment29_High,gcc.segment29))
159: AND (gcc.segment30 is NULL or
160: gcc.segment30 BETWEEN nvl(mtfr_rec.segment30_Low,gcc.segment30) AND nvl(mtfr_rec.segment30_High,gcc.segment30))
161: AND not exists (select 1
162: from FA_ASSET_HIERARCHY ASH
163: where ASH.ASSET_ID = FAAD.ASSET_ID
164: and ASH.PARENT_HIERARCHY_ID is not null
165: )
166: AND faad.asset_id > px_max_asset_id