APPS.FA_CUA_ASSET_APIS dependencies on DUAL

Line 138: from dual

134: where a.asset_hierarchy_id = b.asset_hierarchy_id
135: and bc.book_type_code = a.book_type_code
136: and a.book_type_code in (x_book_type_code,g_corporate_book)
137: and b.asset_hierarchy_id in (select x_top_node_id
138: from dual
139: where nvl(x_rule_det_rec.include_level, 'ALL') = 'TOP'
140: union
141: select x_parent_node_id
142: from dual

Line 142: from dual

138: from dual
139: where nvl(x_rule_det_rec.include_level, 'ALL') = 'TOP'
140: union
141: select x_parent_node_id
142: from dual
143: where nvl(x_rule_det_rec.include_level, 'ALL') = 'LOWEST'
144: union
145: select d.asset_hierarchy_id
146: from fa_asset_hierarchy d

Line 408: from dual

404: connect by asset_hierarchy_id = prior parent_hierarchy_id;
405:
406: CURSOR C_check_lowest_node IS
407: select 1
408: from dual
409: where not exists ( select asset_hierarchy_id
410: from fa_asset_hierarchy
411: where ( parent_hierarchy_id = x_parent_node_id
412: and asset_id IS NULL)