APPS.AR_SUBMIT_LOCKBOX SQL Statements

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

Line: 56

      SELECT  transmission_id,
              requested_lockbox_id,
              requested_trans_format_id,
              transmission_request_id,
              status
      INTO    l_transmission_id,
              l_requested_lockbox_id,
              l_requested_format_id,
              l_orig_request_id,
              l_status
      FROM    ar_transmissions
      WHERE   transmission_name = p_transmission_name;

Line: 264

      SELECT  pay_unrelated_invoices_flag
      INTO    l_pay_unrelated_inv
      FROM    ar_system_parameters
      WHERE   rownum = 1 ;

Line: 279

        SELECT 'Y'
        INTO   l_lb_num_exists
        FROM   ar_trans_field_formats fld,
               ar_trans_record_formats rec
        WHERE  rec.transmission_format_id = l_trans_format_id
        AND    rec.record_type_lookup_code in ('LB HDR', 'LB TRL')
        AND    rec.record_format_id = fld.record_format_id
        AND    fld.field_type_lookup_code = 'LB NUM';

Line: 320

        SELECT loc.gl_date_source
        INTO   l_gl_date_source
        FROM   ar_lockboxes loc
        WHERE  loc.lockbox_id = l_lockbox_id;

Line: 336

            SELECT 'Y'
            INTO l_dep_date_exists
            FROM  ar_trans_record_formats trf,
                 ar_trans_field_formats tff
            WHERE  trf.transmission_format_id = l_trans_format_id
            AND    trf.record_format_id = tff.record_format_id
            AND    tff.field_type_lookup_code = 'DEPOSIT DATE'
            AND    ROWNUM < 2;