[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT p.base_currency_code,
c.precision,
c.minimum_accountable_unit,
c.description
INTO base_curr,
prec,
min_au,
descr
FROM ap_system_parameters p,
fnd_currencies_vl c
WHERE p.base_currency_code = c.currency_code;
SELECT ly.meaning,
ln.meaning,
la.displayed_field
INTO nls_yes, nls_no, nls_all
FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la
WHERE ly.lookup_type = 'YES_NO'
AND ly.lookup_code = 'Y'
AND ln.lookup_type = 'YES_NO'
AND ln.lookup_code = 'N'
AND la.lookup_type = 'NLS REPORT PARAMETER'
AND la.lookup_code = 'ALL';
DELETE FROM ap_vendor_audit_tmp;
SELECT name,
chart_of_accounts_id
INTO l_name,
l_chart_of_accounts_id
FROM gl_sets_of_books
WHERE set_of_books_id = l_sob_id;
CURSOR c1 IS SELECT substr(segment1, 1, 15) vendor_number,
vendor_id,
substr(vendor_name,1,40) vendor_name,
upper(translate(vendor_name,
'a!@#\/~-$%^ ,''*.','a')) new_name,
substr(upper(translate(vendor_name,
'a!@#\/~-$%^ ,''*.','a')),1,p_tst_len)
substr_new_name
FROM po_vendors
WHERE sysdate between nvl(start_date_active,sysdate-1)
and nvl(end_date_active,sysdate+1)
AND enabled_flag='Y'
ORDER BY upper(translate(vendor_name,
'a!@#\/~-$%^ ,''*.','a'));
INSERT INTO ap_vendor_audit_tmp
(vendor_id,
vendor_number,
vendor_name)
VALUES (c_first_match_vendor_id,
c_first_match_vendor_number,
c_first_match_vendor_name);
INSERT INTO ap_vendor_audit_tmp
(vendor_id,
vendor_number,
vendor_name)
VALUES (l_vendor_id,
l_vendor_number,
l_vendor_name);
INSERT INTO ap_vendor_audit_tmp
(vendor_id,
vendor_number,
vendor_name)
VALUES (l_vendor_id,
l_vendor_number,
l_vendor_name);