APPS.OTA_TPC_BUS1 SQL Statements

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

Line: 24

        select cost_level
        from OTA_TP_MEASUREMENT_TYPES
        where tp_measurement_type_id = p_tp_measurement_type_id
        and   business_group_id   = p_business_group_id;

Line: 80

        select null
        from OTA_TRAINING_PLANS
        where training_plan_id    = p_training_plan_id
        and   business_group_id   = p_business_group_id;

Line: 131

        select business_group_id
        from OTA_DELEGATE_BOOKINGS
        where booking_id          = p_booking_id;

Line: 183

        select cost_level
        from OTA_TP_MEASUREMENT_TYPES
        where tp_measurement_type_id = p_tp_measurement_type_id
        and   business_group_id   = p_business_group_id;

Line: 263

        select business_group_id, course_start_date
        from OTA_EVENTS
        where event_id         = p_event_id;

Line: 268

        select ptp.start_date
        from   PER_TIME_PERIODS ptp
              ,OTA_TRAINING_PLANS tps
        where ptp.time_period_id = tps.time_period_id
        and   tps.training_plan_id = p_training_plan_id;

Line: 348

        select null
        from FND_CURRENCIES
        where currency_code = p_currency_code;

Line: 352

        select unit
        from OTA_TP_MEASUREMENT_TYPES
        where tp_measurement_type_id = p_tp_measurement_type_id
        and business_group_id = p_business_group_id;

Line: 464

        select null
        from OTA_TRAINING_PLAN_COSTS
        where tp_measurement_type_id = p_tp_measurement_type_id
        and   training_plan_id       = p_training_plan_id
        and((p_event_id is not null and event_id = p_event_id)
            or  p_event_id is null)
        and((p_booking_id is not null and booking_id = p_booking_id)
            or p_booking_id is null);