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