Line 167: Cursor C_Sel1 is select hr_person_deplymt_contacts_s.nextval from sys.dual;
163: Procedure pre_insert
164: (p_rec in out nocopy hr_pdc_shd.g_rec_type
165: ) is
166: -- 167: Cursor C_Sel1 is select hr_person_deplymt_contacts_s.nextval from sys.dual; 168: --
169: Cursor C_Sel2 is
170: Select null
171: from hr_person_deplymt_contacts