APPS.HZ_ORG_CONTACT_ROLES_PKG dependencies on DUAL

Line 86: INTO X_ORG_CONTACT_ROLE_ID FROM dual;

82: BEGIN
83: l_count := 1;
84: WHILE l_count > 0 LOOP
85: SELECT HZ_ORG_CONTACT_ROLES_S.NEXTVAL
86: INTO X_ORG_CONTACT_ROLE_ID FROM dual;
87: BEGIN
88: SELECT 'Y' INTO l_dummy
89: FROM HZ_ORG_CONTACT_ROLES
90: WHERE ORG_CONTACT_ROLE_ID = X_ORG_CONTACT_ROLE_ID;