APPS.FA_CUA_HIERARCHY_PURPOSE_PKG dependencies on DUAL
Line 24: CURSOR C1 is Select FA_ASSET_HIERARCHY_PURPOSE_S.nextval from sys.dual;
20: is
21: cursor C is select ROWID from FA_ASSET_HIERARCHY_PURPOSE
22: where asset_hierarchy_purpose_id = X_asset_hierarchy_purpose_id ;
23: 24: CURSOR C1 is Select FA_ASSET_HIERARCHY_PURPOSE_S.nextval from sys.dual; 25: begin
26: if X_asset_hierarchy_purpose_id is null then
27: open C1;
28: fetch C1 into X_asset_hierarchy_purpose_id ;