[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
(SELECT null FROM ap_holds M2
WHERE M2.invoice_id = I.invoice_id
AND M2.last_update_date between
NVL('''||to_char(P_START_ACTIVITY_DATE)||''',
M2.last_update_date) and
NVL('''||to_char(P_END_ACTIVITY_DATE)||''',
M2.last_update_date)
AND M2.line_location_id IS NOT NULL)
AND EXISTS
(SELECT null FROM ap_holds M2
WHERE M2.invoice_id = I.invoice_id
AND M2.release_lookup_code is null)
AND ((UPPER('''||P_HOLD_DETAIL_TYPE||''')=''ALL APPROVALS'') OR
((UPPER('''||P_HOLD_DETAIL_TYPE||''')=''AUDIT REPORT'')
AND (M.STATUS_FLAG=''R'' OR M.STATUS_FLAG=''S'')))
');
(SELECT null FROM ap_holds M2
WHERE M2.invoice_id = I.invoice_id
AND M2.last_update_date between
NVL('''||to_char(P_START_ACTIVITY_DATE)||''',
M2.last_update_date) and
NVL('''||to_char(P_END_ACTIVITY_DATE)||''',
M2.last_update_date)
AND M2.line_location_id IS NOT NULL)
AND NOT EXISTS
(SELECT null FROM ap_holds M2
WHERE M2.invoice_id = I.invoice_id
AND M2.release_lookup_code is null)
AND ((UPPER('''||P_HOLD_DETAIL_TYPE||''')=''ALL APPROVALS'') OR
((UPPER('''||P_HOLD_DETAIL_TYPE||''')=''AUDIT REPORT'')
AND (M.STATUS_FLAG=''R'' OR M.STATUS_FLAG=''S'')))
');
(SELECT null FROM ap_holds M2
WHERE M2.invoice_id = I.invoice_id
AND M2.last_update_date between
NVL('''||to_char(P_START_ACTIVITY_DATE)||''',
M2.last_update_date) and
NVL('''||to_char(P_END_ACTIVITY_DATE)||''',
M2.last_update_date)
AND M2.line_location_id IS NOT NULL)
AND ((UPPER('''||P_HOLD_DETAIL_TYPE||''')=''ALL APPROVALS'') OR
((UPPER('''||P_HOLD_DETAIL_TYPE||''')=''AUDIT REPORT'')) AND
(M.STATUS_FLAG=''R'' OR M.STATUS_FLAG=''S''))
');
SELECT p.base_currency_code,
c.precision,
c.minimum_accountable_unit
INTO l_base_curr,
l_prec,
l_min_au
FROM ap_system_parameters p,
fnd_currencies_vl c
WHERE p.base_currency_code = c.currency_code;
SELECT substr(name,1,30),
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;
SELECT ly.meaning,
ln.meaning,
la.displayed_field,
la1.displayed_field
INTO l_nls_yes, l_nls_no, l_nls_all ,l_nls_na
FROM fnd_lookups ly, fnd_lookups ln, ap_lookup_codes la,
ap_lookup_codes la1
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'
AND la1.lookup_type = 'NLS REPORT PARAMETER'
AND la1.lookup_code = 'NA';
SELECT a1c1.displayed_field, a1c2.displayed_field
INTO l_nls_released, l_nls_held
FROM ap_lookup_codes a1c1, ap_lookup_codes a1c2
WHERE a1c1.lookup_type = 'INVOICE HOLD STATUS'
AND a1c1.lookup_code = 'RELEASED'
AND a1c2.lookup_type = 'INVOICE HOLD STATUS'
AND a1c2.lookup_code = 'HELD';