APPS.AHL_MC_PATH_POSITION_PUB SQL Statements

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

Line: 179

    SELECT 'X'
    FROM   AHL_MC_HEADERS_B
    WHERE  mc_id = p_mc_id;

Line: 184

    SELECT mc_id
    FROM   AHL_MC_HEADERS_B
    WHERE  name = p_mc_name;

Line: 189

    SELECT 'X'
    FROM   AHL_MC_HEADERS_B
    WHERE  version_number = p_ver_no
    AND    mc_id          = p_mc_id;

Line: 195

    SELECT version_number
    FROM   AHL_MC_HEADERS_B
    WHERE  revision = p_revision
    AND    mc_id    = p_mc_id;