APPS.AHL_QA_RESULTS_PVT SQL Statements

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

Line: 77

SELECT  plan_id
FROM    QA_RESULTS
WHERE   collection_id = c_collection_id;

Line: 83

SELECT  char_id
FROM    QA_PLAN_CHARS
WHERE   plan_id = c_plan_id;

Line: 91

SELECT workorder_id,
job_number
FROM AHL_SEARCH_WORKORDERS_V
WHERE UNIT_EFFECTIVITY_ID = c_ue_id;

Line: 98

SELECT workorder_id
FROM AHL_WORKORDER_OPERATIONS
WHERE WORKORDER_OPERATION_ID = c_op_id;

Line: 109

SELECT  title
FROM    ahl_unit_effectivities_v
WHERE UNIT_EFFECTIVITY_ID = p_unit_effectivity_id;

Line: 137

    SELECT  organization_id
    INTO    l_organization_id
    FROM    QA_PLANS
    WHERE   plan_id = p_plan_id;

Line: 331

    UPDATE AHL_UNIT_EFFECTIVITIES_B
    SET    qa_collection_id = p_collection_id,
           object_version_number = object_version_number + 1,
           last_update_date = SYSDATE,
           last_updated_by = FND_GLOBAL.user_id,
           last_update_login = FND_GLOBAL.login_id
    WHERE  unit_effectivity_id = l_unit_effectivity_id
    AND    object_version_number = l_object_version_number;

Line: 355

    UPDATE AHL_WORKORDERS
    SET    collection_id = p_collection_id,
           object_version_number = object_version_number + 1,
           last_update_date = SYSDATE,
           last_updated_by = FND_GLOBAL.user_id,
           last_update_login = FND_GLOBAL.login_id
    WHERE  workorder_id = l_workorder_id
    AND    object_version_number = l_object_version_number;

Line: 379

    UPDATE AHL_WORKORDER_OPERATIONS
    SET    collection_id = p_collection_id,
           object_version_number = object_version_number + 1,
           last_update_date = SYSDATE,
           last_updated_by = FND_GLOBAL.user_id,
           last_update_login = FND_GLOBAL.login_id
    WHERE  workorder_operation_id = l_workorder_operation_id
    AND    object_version_number = l_object_version_number;

Line: 554

    SELECT QA_COLLECTION_ID_S.NEXTVAL INTO p_x_collection_id FROM DUAL;

Line: 1005

    SELECT   QP.plan_id
    INTO     x_plan_id
    FROM     QA_PLANS_VAL_V QP,
             QA_PLAN_TRANSACTIONS QPT,
             QA_PLAN_COLLECTION_TRIGGERS QPCT
    WHERE    QP.plan_id = QPT.plan_id
    AND      QPT.plan_transaction_id = QPCT.plan_transaction_id
    AND      QP.organization_id = p_organization_id
    AND      QPT.transaction_number = p_transaction_number
    AND      QPCT.collection_trigger_id = 87
    AND      QPCT.low_value = p_col_trigger_value;