APPS.CSD_PARAMETER_EFFECTIVITY_PVT SQL Statements

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

Line: 100

        SELECT value,NVL(applicable,'N')
        INTO x_param_value,l_always_applicable
        FROM csd_parameter_values
        WHERE parameter_id = p_param_id;

Line: 121

    SELECT rule_id,value
    BULK COLLECT INTO l_param_value_tbl
    FROM csd_return_rules_b
    WHERE source_type = 'RETURN'
        AND source_id = p_param_id
    ORDER BY precedence;

Line: 139

        SELECT rule_condition_id,
            return_rule_id,
            attribute_category,
            attribute1,
            attribute2,
            attribute3,
            attribute4,
            attribute5,
            attribute6,
            attribute7,
            attribute8,
            attribute9,
            attribute10,
            attribute11,
            attribute12,
            attribute13,
            attribute14,
            attribute15
        BULK COLLECT INTO l_rule_condition_tbl
        FROM csd_ret_rule_conditions_b
        WHERE return_rule_id = l_param_value_tbl(i).rule_id;