APPS.OTA_OFF_BUS dependencies on OTA_OFFERINGS_VL

Line 758: SELECT 1 FROM OTA_OFFERINGS_VL OFF

754: := G_PACKAGE || 'UNIQUE_OFFERING_TITLE';
755: W_TITLE_IS_UNIQUE boolean;
756: --
757: cursor C1 is
758: SELECT 1 FROM OTA_OFFERINGS_VL OFF
759: WHERE OFF.NAME = P_NAME
760: AND OFF.ACTIVITY_VERSION_ID = P_ACTIVITY_VERSION_ID
761: AND OFF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
762: AND ( OFF.OFFERING_ID <> P_OFFERING_ID or P_OFFERING_ID IS NULL ) ;