APPS.OTA_CPR_SHD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 59

    select
       activity_version_id
      ,prerequisite_course_id
      ,business_group_id
      ,prerequisite_type
      ,enforcement_mode
      ,object_version_number
    from        ota_course_prerequisites
    where       activity_version_id = p_activity_version_id
    and   prerequisite_course_id = p_prerequisite_course_id;

Line: 135

    select
       activity_version_id
      ,prerequisite_course_id
      ,business_group_id
      ,prerequisite_type
      ,enforcement_mode
      ,object_version_number
    from        ota_course_prerequisites
    where       activity_version_id = p_activity_version_id
    and   prerequisite_course_id = p_prerequisite_course_id
    for update nowait;