APPS.OE_DEFAULT_LINE_PAYMENT SQL Statements

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

Line: 152

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

          --bug3504713 setting the defer_payment_processing_flag to null if payment_type_code is 'COMMITMENT'
	  IF l_payment_type_code = 'COMMITMENT' THEN
              p_x_line_Payment_rec.defer_payment_processing_flag := null;

Line: 167

              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: 244

           SELECT header_id
           INTO l_header_id
           FROM oe_order_lines_all
           WHERE line_id = p_line_id;

Line: 250

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

Line: 262

        SELECT  NVL(MAX(PAYMENT_NUMBER)+1,1)
        INTO    l_payment_number
        FROM    OE_PAYMENTS
        WHERE   header_id = l_header_id
        AND     LINE_ID = p_line_id;

Line: 268

        SELECT  MAX(NVL(PAYMENT_NUMBER, 1))+1
        INTO    l_payment_number
        FROM    OE_PAYMENTS
        WHERE   header_id = l_header_id
        AND     LINE_ID = p_line_id;