APPS.FA_CUA_ASSET_APIS dependencies on FA_EXCLUDE_HIERARCHY_LEVELS

Line 152: from fa_exclude_hierarchy_levels c

148: start with d.asset_hierarchy_id = x_parent_node_id
149: connect by d.asset_hierarchy_id = prior d.parent_hierarchy_id
150: )
151: and not exists (select 'X'
152: from fa_exclude_hierarchy_levels c
153: where c.attribute_name = 'LIFE_END_DATE'
154: and c.book_type_code= x_book_type_code
155: and c.hierarchy_rule_set_id = x_rule_det_rec.hierarchy_rule_set_id
156: and b.level_number = c.level_number