Line 217: Cursor C_Sel1 is select ghr_compl_agency_appeals_s.nextval from sys.dual;
213: Procedure pre_insert
214: (p_rec in out nocopy ghr_caa_shd.g_rec_type
215: ) is
216: -- 217: Cursor C_Sel1 is select ghr_compl_agency_appeals_s.nextval from sys.dual; 218: --
219: Cursor C_Sel2 is
220: Select null
221: from ghr_compl_agency_appeals