Line 37: CURSOR C2 IS SELECT fa_trx_references_s.nextval FROM dual;
33:
34: CURSOR C IS SELECT rowid FROM fa_trx_references
35: WHERE trx_reference_id = X_Trx_Reference_Id;
36: 37: CURSOR C2 IS SELECT fa_trx_references_s.nextval FROM dual; 38:
39: BEGIN
40: if (X_Trx_Reference_Id is NULL) then
41: OPEN C2;