APPS.FA_CUA_ASSET_APIS dependencies on DUAL

Line 141: from dual

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

Line 145: from dual

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

Line 412: from dual

408: connect by asset_hierarchy_id = prior parent_hierarchy_id;
409:
410: CURSOR C_check_lowest_node IS
411: select 1
412: from dual
413: where not exists ( select asset_hierarchy_id
414: from fa_asset_hierarchy
415: where ( parent_hierarchy_id = x_parent_node_id
416: and asset_id IS NULL)