APPS.ARI_SELF_REGISTRATION_PKG dependencies on UMX_REG_SERVICES_VL

Line 273: FROM UMX_REG_SERVICES_VL REGSRVC

269: ----------------------------------------------------------------------------
270: BEGIN
271: SELECT REGSRVC.REG_SERVICE_TYPE
272: INTO l_reg_service_type
273: FROM UMX_REG_SERVICES_VL REGSRVC
274: WHERE REGSRVC.REG_SERVICE_CODE = p_reg_service_code
275: AND REGSRVC.START_DATE <= SYSDATE
276: AND NVL(REGSRVC.END_DATE, SYSDATE+1) > SYSDATE;
277: EXCEPTION