APPS.QP_DEFAULT_CURR_LISTS SQL Statements

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

Line: 30

    select QP_CURRENCY_LISTS_B_S.nextval
    into   l_currency_header_id
    from   dual;

Line: 460

    IF g_CURR_LISTS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_CURR_LISTS_rec.last_updated_by := NULL;

Line: 466

    IF g_CURR_LISTS_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_CURR_LISTS_rec.last_update_date := NULL;

Line: 472

    IF g_CURR_LISTS_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_CURR_LISTS_rec.last_update_login := NULL;

Line: 490

    IF g_CURR_LISTS_rec.program_update_date = FND_API.G_MISS_DATE THEN

        g_CURR_LISTS_rec.program_update_date := NULL;

Line: 525

    OR  g_CURR_LISTS_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_CURR_LISTS_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_CURR_LISTS_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_CURR_LISTS_rec.name = FND_API.G_MISS_CHAR
    OR  g_CURR_LISTS_rec.program_application_id = FND_API.G_MISS_NUM
    OR  g_CURR_LISTS_rec.program_id = FND_API.G_MISS_NUM
    OR  g_CURR_LISTS_rec.program_update_date = FND_API.G_MISS_DATE
    OR  g_CURR_LISTS_rec.request_id = FND_API.G_MISS_NUM
    OR  g_CURR_LISTS_rec.request_id = FND_API.G_MISS_NUM
    OR  g_CURR_LISTS_rec.base_rounding_factor = FND_API.G_MISS_NUM
    OR  g_CURR_LISTS_rec.base_markup_operator = FND_API.G_MISS_CHAR
    OR  g_CURR_LISTS_rec.base_markup_value = FND_API.G_MISS_NUM
    OR  g_CURR_LISTS_rec.base_markup_formula_id = FND_API.G_MISS_NUM
    -- OR  g_CURR_LISTS_rec.row_id = FND_API.G_MISS_NUM --Commented by Sunil
    THEN

        QP_Default_Curr_Lists.Attributes
        (   p_CURR_LISTS_rec              => g_CURR_LISTS_rec
        ,   p_iteration                   => p_iteration + 1
        ,   x_CURR_LISTS_rec              => x_CURR_LISTS_rec
        );