DBA Data[Home] [Help]

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 ;