APPS.OTA_TRAINING_PLAN_UPGRADE dependencies on OTA_EVENT_ASSOCIATIONS

Line 487: FROM ota_event_associations tea

483: WHERE path_source_code IS null;
484:
485: UPDATE ota_learning_paths lps
486: SET public_flag = (SELECT decode(count(tea.learning_path_id),0,'Y','N')
487: FROM ota_event_associations tea
488: WHERE lps.learning_path_id = tea.learning_path_id)
489: WHERE lps.public_flag IS NULL
490: AND lps.path_source_code = 'CATALOG';
491: