APPS.ARH_CROL_PKG dependencies on DUAL

Line 323: select hz_org_contact_roles_s.nextval into x_contact_role_id from dual;

319: end if;
320: --
321: l_count := 1;
322: while l_count > 0 loop
323: select hz_org_contact_roles_s.nextval into x_contact_role_id from dual;
324:
325: select count(*) into l_count from hz_org_contact_roles
326: where org_contact_role_id = x_contact_role_id ;
327:

Line 361: select hz_role_responsibility_s.nextval into x_contact_role_id from dual;

357: -- role_rec.attribute15 := x_Attribute15;
358: l_count := 1;
359:
360: while l_count > 0 loop
361: select hz_role_responsibility_s.nextval into x_contact_role_id from dual;
362:
363: select count(*) into l_count from hz_role_responsibility
364: where responsibility_id = x_contact_role_id;
365: