APPS.OE_DEFAULT_HEADER_PAYMENT SQL Statements

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

Line: 143

             and p_x_header_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE)
             or
               (nvl(p_x_header_Payment_rec.defer_payment_processing_flag,
                     FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR
               and p_x_header_Payment_rec.operation = OE_GLOBALS.G_OPR_CREATE)
             or
               (nvl(p_old_header_Payment_rec.defer_payment_processing_flag,
                     FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
               and p_x_header_Payment_rec.operation = OE_GLOBALS.G_OPR_CREATE)
            )
        then

           select defer_payment_processing_flag into l_defer
           from oe_payment_types_all
           where payment_type_code = l_payment_type_code
           and nvl(org_id, -99) = nvl(l_org_id, -99);

Line: 226

        SELECT 'Y'
        INTO   l_exists_null_number
        FROM   oe_payments
        WHERE  payment_number is null
        AND    header_id = p_header_id
        AND    line_id is null
        AND    rownum = 1;

Line: 238

        SELECT  NVL(MAX(PAYMENT_NUMBER)+1,1)
        INTO    l_payment_number
        FROM    OE_PAYMENTS
        WHERE   HEADER_ID = p_header_id
        AND     LINE_ID IS NULL;

Line: 244

        SELECT  MAX(NVL(PAYMENT_NUMBER, 1))+1
        INTO    l_payment_number
        FROM    OE_PAYMENTS
        WHERE   HEADER_ID = p_header_id
        AND     LINE_ID IS NULL;