APPS.FA_CUA_WB_EXT_PKG dependencies on FA_ASSET_HIERARCHY

Line 18: from fa_asset_hierarchy

14: PROCEDURE facuas1 ( x_asset_id in number ) IS
15:
16: Cursor C1 is
17: select asset_hierarchy_id
18: from fa_asset_hierarchy
19: where asset_id = x_asset_id;
20: Begin
21: FOR c1_rec in C1 LOOP
22: delete from FA_ASSET_HIERARCHY

Line 22: delete from FA_ASSET_HIERARCHY

18: from fa_asset_hierarchy
19: where asset_id = x_asset_id;
20: Begin
21: FOR c1_rec in C1 LOOP
22: delete from FA_ASSET_HIERARCHY
23: where asset_hierarchy_id = c1_rec.asset_hierarchy_id;
24: END LOOP;
25: End facuas1;
26: