Line 44: CURSOR C2 IS SELECT eam_wo_statuses_b_s.nextval FROM sys.dual;
40: cursor C is select ROWID from eam_safety_usr_def_statuses_b
41: where STATUS_ID = X_STATUS_ID and
42: entity_type = P_ENTITY_TYPE;
43: 44: CURSOR C2 IS SELECT eam_wo_statuses_b_s.nextval FROM sys.dual; 45:
46: begin
47: if (X_Status_Id is NULL) then
48: OPEN C2;