DBA Data[Home] [Help]

APPS.OTA_CLASSIC_UPGRADE dependencies on OTA_EVENT_ASSOCIATIONS

Line 2174: update OTA_EVENT_ASSOCIATIONS

2170: p_update_id in number default 1 ) is
2171:
2172: l_rows_processed number;
2173: begin
2174: update OTA_EVENT_ASSOCIATIONS
2175: set self_enrollment_flag = 'N'
2176: where event_association_id between p_start_pkid and p_end_pkid
2177: and self_enrollment_flag is null -- Bug#6804783
2178: and ( customer_id is not null

Line 2186: from OTA_EVENT_ASSOCIATIONS

2182:
2183:
2184: select nvl(count(event_association_id),0)
2185: into l_rows_processed
2186: from OTA_EVENT_ASSOCIATIONS
2187: where event_association_id between p_start_pkid and p_end_pkid ;
2188:
2189: p_rows_processed := l_rows_processed;
2190: