DBA Data[Home] [Help]

APPS.ARH_CROL_PKG dependencies on HZ_ORG_CONTACT_ROLES

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 325: select count(*) into l_count from hz_org_contact_roles

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:
328: END LOOP;
329: --