The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* 5921925 - copy info from arp_global.sysparam rather than selecting
from the db (again) */
arp_global.init_global;
trx_profile_rec.ar_update_due_date := fnd_profile.value('AR_UPDATE_DUE_DATE');
trx_profile_rec.ar_allow_salescredit_update := fnd_profile.value('AR_ALLOW_SALESCREDIT_UPDATE');
SELECT user_conversion_type
INTO l_user_conversion_type
FROM GL_DAILY_CONVERSION_TYPES
WHERE conversion_type = l_profile_value;
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';
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';
UPDATE ar_trx_header_gt
SET gl_date = l_default_gl_date
WHERE trx_header_id = ar_invoice_gt_rec.trx_header_id;
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;