APPS.QP_DEFAULT_QUALIFIER_RULES SQL Statements

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

Line: 38

    SELECT QP_QUALIFIER_RULES_S.NEXTVAL
    INTO l_qualifier_rule_id
    FROM DUAL;

Line: 258

    IF g_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_QUALIFIER_RULES_rec.last_updated_by := NULL;

Line: 264

    IF g_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_QUALIFIER_RULES_rec.last_update_date := NULL;

Line: 270

    IF g_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_QUALIFIER_RULES_rec.last_update_login := NULL;

Line: 288

    IF g_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_QUALIFIER_RULES_rec.program_update_date := NULL;

Line: 321

    OR  g_QUALIFIER_RULES_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_QUALIFIER_RULES_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_QUALIFIER_RULES_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_QUALIFIER_RULES_rec.name = FND_API.G_MISS_CHAR
    OR  g_QUALIFIER_RULES_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_QUALIFIER_RULES_rec.program_id = FND_API.G_MISS_NUM
    OR  g_QUALIFIER_RULES_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_QUALIFIER_RULES_rec.qualifier_rule_id = FND_API.G_MISS_NUM
    OR  g_QUALIFIER_RULES_rec.request_id = FND_API.G_MISS_NUM
    THEN

        QP_Default_Qualifier_Rules.Attributes
        (   p_QUALIFIER_RULES_rec         => g_QUALIFIER_RULES_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_QUALIFIER_RULES_rec         => x_QUALIFIER_RULES_rec
        );