APPS.OTA_EVT_SHD dependencies on OTA_PROGRAM_MEMBERSHIPS

Line 63: ElsIf (p_constraint_name = 'OTA_PROGRAM_MEMBERSHIPS_FK1') Then

59: ElsIf (p_constraint_name = 'OTA_EVENTS_FK5') Then
60: FND_MESSAGE.SET_NAME('OTA','OTA_13433_EVT_NO_PAR');
61: fnd_message.raise_error;
62: /* 3803613 */
63: ElsIf (p_constraint_name = 'OTA_PROGRAM_MEMBERSHIPS_FK1') Then
64: FND_MESSAGE.SET_NAME('OTA','OTA_13681_EVT_PMM_EXISTS');
65: fnd_message.raise_error;
66: /* 3803613 */
67: ElsIf (p_constraint_name = 'OTA_EVENTS_PK') Then

Line 755: from ota_program_memberships mem,

751: l_found boolean := false;
752: --
753: cursor c1 is
754: select null
755: from ota_program_memberships mem,
756: ota_events evt
757: where mem.program_event_id = p_event_id
758: and mem.event_id = evt.event_id
759: and evt.event_status = 'P';