Line 182: Cursor C_Sel1 is select ghr_compl_claims_s.nextval from sys.dual;
178: Procedure pre_insert
179: (p_rec in out nocopy ghr_ccl_shd.g_rec_type
180: ) is
181: -- 182: Cursor C_Sel1 is select ghr_compl_claims_s.nextval from sys.dual; 183: --
184: Cursor C_Sel2 is
185: Select null
186: from ghr_compl_claims