APPS.AR_INVOICE_DEFAULT_PVT SQL Statements

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

Line: 18

    /* 5921925 - copy info from arp_global.sysparam rather than selecting
       from the db (again) */
    arp_global.init_global;

Line: 137

       trx_profile_rec.ar_update_due_date := fnd_profile.value('AR_UPDATE_DUE_DATE');

Line: 139

       trx_profile_rec.ar_allow_salescredit_update := fnd_profile.value('AR_ALLOW_SALESCREDIT_UPDATE');

Line: 149

           SELECT user_conversion_type
           INTO l_user_conversion_type
	       FROM GL_DAILY_CONVERSION_TYPES
	       WHERE conversion_type = l_profile_value;

Line: 154

	       SELECT user_profile_option_name
	       INTO l_user_profile_option_name
           FROM FND_PROFILE_OPTIONS_VL
           WHERE application_id = 222
           AND profile_option_name = 'AR_DEFAULT_EXCHANGE_RATE_TYPE';

Line: 286

    SELECT nvl(hdr.trx_date, sysdate) trx_date, hdr.set_of_books_id,
           hdr.trx_header_id
    FROM ar_trx_header_gt  hdr,
         ra_cust_trx_types tt
    WHERE gl_date IS NULL
    AND   hdr.cust_trx_type_id = tt.cust_trx_type_id
    AND   NVL(tt.post_to_gl,'N') = 'Y';

Line: 323

      UPDATE ar_trx_header_gt
        SET  gl_date = l_default_gl_date
      WHERE trx_header_id = ar_invoice_gt_rec.trx_header_id;

Line: 327

      UPDATE ar_trx_dist_gt
        SET gl_date = l_default_gl_date
      WHERE trx_header_id = ar_invoice_gt_rec.trx_header_id
        AND  gl_date is null;