[Home] [Help]
APPS.OKL_MASTER_LEASE_AGREEMENT_PUB SQL Statements
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Line: 57
select sar.id
from okc_std_articles_v sar,
okc_std_art_versions_v svr
where sar.id = svr.sae_id
and sar.name = p_name
and svr.sav_release = p_version;
Line: 66
SELECT id
FROM okc_k_headers_v
WHERE contract_number = p_credit_line;
Line: 96
l_chrv_rec.DELETED_YN := 'N';