APPS.AHL_UA_FLIGHT_SCHEDULES_PUB SQL Statements

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

Line: 78

    l_search_Query := 'SELECT
                UNIT_SCHEDULE_ID,
                FLIGHT_NUMBER, SEGMENT,
                DEPARTURE_DEPT_ID,
                DEPARTURE_DEPT_CODE,
                DEPARTURE_ORG_ID,
                DEPARTURE_ORG_CODE,
                ARRIVAL_DEPT_ID,
                ARRIVAL_DEPT_CODE,
                ARRIVAL_ORG_ID,
                ARRIVAL_ORG_CODE,
                EST_DEPARTURE_TIME,
                EST_ARRIVAL_TIME,
                ACTUAL_DEPARTURE_TIME,
                ACTUAL_ARRIVAL_TIME,
                PRECEDING_US_ID,
                CSI_ITEM_INSTANCE_ID,
                UNIT_CONFIG_HEADER_ID,
                UNIT_CONFIG_NAME,
                VISIT_RESCHEDULE_MODE,
                VISIT_RESCHEDULE_MEANING,
                ITEM_NUMBER,
                SERIAL_NUMBER,
                OBJECT_VERSION_NUMBER,
                ATTRIBUTE_CATEGORY,
                ATTRIBUTE1,
                ATTRIBUTE2,
                ATTRIBUTE3,
                ATTRIBUTE4,
                ATTRIBUTE5,
                ATTRIBUTE6,
                ATTRIBUTE7,
                ATTRIBUTE8,
                ATTRIBUTE9,
                ATTRIBUTE10,
                ATTRIBUTE11,
                ATTRIBUTE12,
                ATTRIBUTE13,
                ATTRIBUTE14,
                ATTRIBUTE15
            FROM
                 AHL_UNIT_SCHEDULES_V
            WHERE AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(UNIT_CONFIG_HEADER_ID) NOT IN (''DRAFT'',''EXPIRED'')';

Line: 417

        x_flight_schedules_tbl(i).is_delete_allowed := AHL_UA_FLIGHT_SCHEDULES_PVT.is_delete_allowed(
                                 p_unit_schedule_id => x_flight_schedules_tbl(i).unit_schedule_id,
                                 p_is_super_user =>  l_super_user
                               );

Line: 421

        x_flight_schedules_tbl(i).is_update_allowed := AHL_UA_FLIGHT_SCHEDULES_PVT.is_update_allowed(
                                 p_unit_schedule_id => x_flight_schedules_tbl(i).unit_schedule_id,
                                 p_is_super_user => l_super_user
                               );