[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT irp.delinquency_id
,ico.cas_id
,ico.object_id contract_id
,alv.asset_id
,alv.parent_line_id
FROM iex_repossessions irp
,iex_delinquencies_all ida
,iex_case_objects ico
,okx_asset_lines_v alv
,okl_cnsld_ar_strms_b stream
WHERE irp.repossession_id = cp_repossession_id
AND irp.delinquency_id = ida.delinquency_id
and ida.transaction_id =stream.RECEIVABLES_INVOICE_ID
and stream.khr_id=ico.object_id
AND ico.object_id = alv.dnz_chr_id
AND alv.asset_id = cp_asset_id;
select alv.parent_line_id from iex_repossessions irp, okx_asset_lines_v alv
where alv.asset_id = cp_asset_id
and irp.repossession_id = cp_repossession_id
and alv.dnz_chr_id = irp.contract_id;
iex_repos_objects_pub.insert_repos_objects(
p_api_version => p_api_version
,p_init_msg_list => p_init_msg_list
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_repv_rec => lp_repv_rec
,x_repv_rec => lx_repv_rec);