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 750: from ota_program_memberships mem,

746: l_found boolean := false;
747: --
748: cursor c1 is
749: select null
750: from ota_program_memberships mem,
751: ota_events evt
752: where mem.program_event_id = p_event_id
753: and mem.event_id = evt.event_id
754: and evt.event_status = 'P';