[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT RULE_INFORMATION1,
RULE_INFORMATION2
FROM OKC_RULES_B rul,
Okc_rule_groups_B rgp
WHERE rul.rgp_id = rgp.id AND
rgp.rgd_code = 'LASEIR' AND
rul.rule_information_category = 'LASEIR' AND
rgp.dnz_chr_id = p_khr_id;
SELECT VENDOR_NAME
FROM po_vendors
WHERE VENDOR_ID = p_vendor_id;
SELECT VENDOR_SITE_CODE
FROM po_vendor_sites
WHERE VENDOR_SITE_ID = p_vendor_site_id;
SELECT chr.authoring_org_id
FROM okc_k_headers_b chr
WHERE id = p_chr_id;
SELECT hru.set_of_books_id
FROM HR_OPERATING_UNITS HRU
WHERE ORGANIZATION_ID = p_org_id;
SELECT id
FROM okl_trx_types_tl
WHERE name = 'Disbursement'
AND language= 'US';
SELECT rul.object1_id1, -- Pay To Vendor Name
rul.object2_id1, -- Pay Site
rul.OBJECT3_ID1, -- Payment Term
RULE_INFORMATION1, -- Payment Method
RULE_INFORMATION2 -- Pay Group
FROM OKC_RULES_B rul,
Okc_rule_groups_B rgp
WHERE rul.rgp_id = rgp.id AND
rgp.rgd_code = 'LASEDB' AND
rul.rule_information_category = 'LASEDB' AND
rgp.dnz_chr_id = p_khr_id AND
rgp.cle_id = p_kle_id;
SELECT ap_invoices_interface_s.nextval
FROM dual;
SELECT name
FROM OKL_STRM_TYPE_V
WHERE id = p_sty_id;
SELECT NVL(SUM(SEL.AMOUNT),0)
FROM OKL_STREAMS STM,
OKL_STRM_ELEMENTS SEL,
OKL_STRM_TYPE_V STY
WHERE STM.KHR_ID = p_rbk_khr_id
AND NVL(STM.KLE_ID,-99) = NVL ( p_rbk_kle_id,-99 )
AND STM.STY_ID = STY.ID
AND stm.source_table = 'OKL_K_HEADERS'
AND stm.source_id = p_ia_id
AND STM.SAY_CODE = 'CURR'
AND (STY.STREAM_TYPE_SUBCLASS = 'INVESTOR_DISBURSEMENT'
OR STY.stream_type_purpose in ( 'INVESTOR_RENT_DISB_BASIS','INVESTOR_PRINCIPAL_DISB_BASIS','INVESTOR_INTEREST_DISB_BASIS','INVESTOR_PPD_DISB_BASIS'))
AND SEL.STM_ID = STM.ID
AND SEL.DATE_BILLED IS NOT NULL;
select add_months(l_next_date, l_mnth_adder) INTO l_next_date from dual;
SELECT receivables_invoice_id
FROM okl_cnsld_ar_strms_b
WHERE sel_id = p_ref_sel_id AND
receivables_invoice_id IS NOT NULL;
SELECT customer_trx_id
FROM okl_bpd_tld_ar_lines_v
WHERE sel_id = p_ref_sel_id AND
customer_trx_id IS NOT NULL;
SELECT NVL(SUM(ARAPP.amount_applied),0)
FROM
OKL_CNSLD_AR_STRMS_V LSM,
AR_PAYMENT_SCHEDULES_ALL PMTSCH,
AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
WHERE
LSM.ID = p_lsm_id AND
PMTSCH.customer_trx_id = LSM.receivables_invoice_id AND
ARAPP.applied_payment_schedule_id = PMTSCH.payment_schedule_id AND
PMTSCH.class = 'INV' AND
exists (
SELECT '1'
FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay
WHERE pay.receivable_application_id = ARAPP.receivable_application_id AND
pay.lsm_id = LSM.ID
);
SELECT NVL(SUM(ARAPP.amount_applied),0)
FROM
--start:| 09-Mar-2007 cklee code fixed to refer to proper FK
-- OKL_CNSLD_AR_STRMS_V LSM,
--end:| 09-Mar-2007 cklee code fixed to refer to proper FK
okl_bpd_tld_ar_lines_v TLD,
AR_PAYMENT_SCHEDULES_ALL PMTSCH,
AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
WHERE
--start:| 09-Mar-2007 cklee code fixed to refer to proper FK
-- LSM.ID = p_lsm_id AND
--end:| 09-Mar-2007 cklee code fixed to refer to proper FK
TLD.TLD_ID = p_tld_id AND
PMTSCH.customer_trx_id = TLD.customer_trx_id AND
ARAPP.applied_payment_schedule_id = PMTSCH.payment_schedule_id AND
PMTSCH.class = 'INV' AND
exists (
SELECT '1'
FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay
WHERE pay.receivable_application_id = ARAPP.receivable_application_id AND
--start:| 09-Mar-2007 cklee code fixed to refer to proper FK
-- pay.lsm_id = TLD.TLD_ID );
SELECT PMTSCH.amount_due_original
FROM OKL_CNSLD_AR_STRMS_V LSM,
AR_PAYMENT_SCHEDULES_ALL PMTSCH
WHERE LSM.ID = p_lsm_id AND
PMTSCH.customer_trx_id = LSM.receivables_invoice_id AND
PMTSCH.class = 'INV';
SELECT PMTSCH.amount_due_original
--start:| 09-Mar-2007 cklee code fixed to refer to proper FK
-- FROM OKL_CNSLD_AR_STRMS_V LSM,
--end:| 09-Mar-2007 cklee code fixed to refer to proper FK
FROM okl_bpd_tld_ar_lines_v TLD,
AR_PAYMENT_SCHEDULES_ALL PMTSCH
--start:| 09-Mar-2007 cklee code fixed to refer to proper FK
-- WHERE LSM.ID = p_lsm_id AND
--end:| 09-Mar-2007 cklee code fixed to refer to proper FK
WHERE TLD.TLD_ID = p_tld_id AND
PMTSCH.customer_trx_id = TLD.customer_trx_id AND
PMTSCH.class = 'INV';
SELECT TLD_ID
FROM okl_bpd_tld_ar_lines_v
WHERE sel_id = p_ref_sel_id;
SELECT ID
FROM OKL_CNSLD_AR_STRMS_V
WHERE sel_id = p_ref_sel_id;
SELECT tld_id
FROM okl_bpd_tld_ar_lines_v
-- WHERE tld_id = p_ref_sel_id;
SELECT ia.id,
ia.authoring_org_id,
ia.currency_code,
ia_okl.currency_conversion_type,
ia_okl.currency_conversion_rate,
ia_okl.currency_conversion_date,
ia_okl.legal_entity_id
FROM okc_k_headers_b ia,
okl_k_headers ia_okl
WHERE ia.contract_number = p_investor_agreement
AND ia_okl.id = ia.id;
SELECT
clet.id , -- investor line id
clet.cust_acct_id,
clet.bill_to_site_use_id,
klet.pay_investor_event,
klet.pay_investor_frequency,
klet.date_pay_investor_start,
klet.pay_investor_remittance_days
FROM okl_k_headers_full_v khr,
okl_k_lines klet,
okc_k_lines_b clet,
okc_line_styles_b lset
WHERE khr.id = p_ia_id
AND klet.id = clet.id
AND khr.id = clet.dnz_chr_id
AND clet.lse_id = lset.id
AND lset.lty_code = 'INVESTMENT'
ORDER BY 1;
SELECT okc_fee_line.id
, okc_fee_line.start_date
, NVL(okl_fee_line.amount,0) amount
, okl_fee_line.fee_type
FROM okc_k_lines_b okc_fee_line ,
okl_k_lines okl_fee_line ,
okc_line_styles_b lse ,
okc_k_party_roles_b inv_line_role ,
okc_k_party_roles_b fee_line_role
WHERE inv_line_role.cle_id = p_investor_line_id
AND inv_line_role.dnz_chr_id = p_ia_id
AND inv_line_role.object1_id1 = fee_line_role.object1_id1
AND inv_line_role.rle_code = fee_line_role.rle_code
AND inv_line_role.dnz_chr_id = fee_line_role.dnz_chr_id
AND fee_line_role.cle_id = okc_fee_line.id
AND okc_fee_line.lse_id = lse.id
AND lse.lty_code = 'FEE'
AND okc_fee_line.chr_id = fee_line_role.dnz_chr_id
AND okc_fee_line.id = okl_fee_line.id
AND okl_fee_line.fee_type = 'EXPENSE'
AND trunc(okc_fee_line.start_date) <= trunc(NVL(p_to_date, SYSDATE));
SELECT NVL(SUM(b.amount),0)
FROM okl_trx_ap_invoices_b a,
okl_txl_ap_inv_lns_b b
WHERE a.id = b.tap_id
AND a.trx_status_code in ('ENTERED', 'APPROVED', 'PROCESSED')
AND b.amount > 0
AND b.khr_id = p_ia_id
AND b.kle_id = p_fee_line_id
AND EXISTS (SELECT NULL
FROM okx_vendor_sites_v vs
WHERE vs.id1 = a.ipvs_id
AND vs.id1 = p_vendor_site_id);
SELECT object1_id1 fee_sty_id
FROM okc_k_items
WHERE cle_id = p_fee_line_id;
SELECT DISTINCT
IA.contract_number Investor_Agreement,
IA.id Investor_Agreement_ID,
IA.pdt_id pdt_id,
IA.currency_code,
IA.currency_conversion_type,
IA.currency_conversion_rate,
IA.currency_conversion_date,
Poc.khr_id
-- 02-NOV-2006 ANSETHUR R12B - Legal Entity
,IA.legal_entity_id
FROM OKL_POOLS pol,
okl_k_headers_full_v IA,
okl_pool_contents_v poc,
okl_k_headers_full_v LK_KHR
WHERE IA.Contract_number = NVL( p_inv_agr, IA.Contract_number)
AND IA.ID = POL.khr_id
AND pol.id = poc.pol_id
AND poc.khr_id = LK_KHR.id;
SELECT
stm.khr_id khr_id,
TRUNC (ste.stream_element_date) bill_date,
stm.kle_id kle_id,
ste.id sel_id,
ste.sel_id ref_sel_id,
stm.sty_id sty_id,
khr.contract_number lease_contract,
khr.currency_code currency_code,
khr.authoring_org_id authoring_org_id,
sty.stream_type_purpose stream_purpose,
sty.name stream_name,
sty.taxable_default_yn taxable_default_yn,
sty.stream_type_subclass subclass,
ste.amount amount,
khr.sts_code sts_code
--ssiruvol Bug 5000886 start
,(select id
from OKL_TXD_AR_LN_DTLS_B cnsld
where cnsld.khr_id=p_lk_khr_id
AND cnsld.sel_id =ste.sel_id
--AND cnsld.receivables_invoice_id IS NOT NULL
)
cnsld_id,
--ssiruvol Bug 5000886 end
oklh.deal_type deal_type
FROM
okl_strm_elements ste,
okl_streams stm,
okl_strm_type_v sty,
okc_k_headers_b khr,
okl_k_headers oklh
WHERE trunc(ste.stream_element_date) <= trunc(NVL(p_date_to, SYSDATE))
AND ste.amount <> 0
AND stm.id = ste.stm_id
AND sty.stream_type_subclass IN ('INVESTOR_DISBURSEMENT','LATE_CHARGE')
--Added by bkatraga for bug 6983321
AND sty.stream_type_purpose NOT IN('INVESTOR_RENT_DISB_BASIS')
--end bkatraga
AND ste.date_billed IS NULL
AND stm.active_yn = 'Y'
AND stm.say_code = 'CURR'
-- New Criteria added for further refining the
-- search criteria
AND stm.source_table = 'OKL_K_HEADERS'
AND stm.source_id = p_ia_id
-- End new criteria
AND sty.id = stm.sty_id
AND khr.id = stm.khr_id
AND khr.ID = p_lk_khr_id
AND khr.id = oklh.id
--Added by bkatraga for bug 6983321
UNION ALL
--end bkatraga
SELECT
stm.khr_id khr_id,
TRUNC (ste.stream_element_date) bill_date,
stm.kle_id kle_id,
ste.id sel_id,
ste.sel_id ref_sel_id,
stm.sty_id sty_id,
khr.contract_number lease_contract,
khr.currency_code currency_code,
khr.authoring_org_id authoring_org_id,
sty.stream_type_purpose stream_purpose,
sty.name stream_name,
sty.taxable_default_yn taxable_default_yn,
sty.stream_type_subclass subclass,
ste.amount amount,
khr.sts_code sts_code
--ssiruvol Bug 5000886 start
,(select id
from OKL_TXD_AR_LN_DTLS_B cnsld
where cnsld.khr_id=p_lk_khr_id
AND cnsld.sel_id =ste.sel_id
--AND cnsld.receivables_invoice_id IS NOT NULL
)
cnsld_id,
--ssiruvol Bug 5000886 end
khl.deal_type deal_type
FROM
okl_strm_elements ste,
-- Bug 4550607
okl_strm_elements ste1,
-- End Bug 4550607
okl_streams stm,
okl_strm_type_v sty,
okc_k_headers_b khr,
okl_k_headers khl,
okc_statuses_b khs ,
--Added by bkatraga for bug 6983321
okl_pools pl,
okl_pool_contents plcont
--pgomes fix for bug 4430377
WHERE trunc(ste.stream_element_date) <= trunc(NVL(p_date_to, SYSDATE))
AND ste.amount <> 0
AND stm.id = ste.stm_id
AND sty.stream_type_subclass IS NULL
AND sty.stream_type_purpose in ( 'INVESTOR_RENT_DISB_BASIS','INVESTOR_PRINCIPAL_DISB_BASIS','INVESTOR_INTEREST_DISB_BASIS','INVESTOR_PPD_DISB_BASIS')
AND ste.date_billed IS NULL
-- New Criteria added for further refining the
-- search criteria
AND stm.source_table = 'OKL_K_HEADERS'
AND stm.source_id = p_ia_id
-- End new criteria
AND sty.id = stm.sty_id
AND sty.billable_yn = 'N'
AND khr.id = stm.khr_id
AND khr.scs_code IN ('LEASE', 'LOAN')
-- AND khr.sts_code IN ( 'BOOKED','EVERGREEN')
--Added TERMINATED, EXPIRED statuses by bkatraga for bug 7120711
AND khr.sts_code IN ( 'BOOKED','EVERGREEN','TERMINATED','EXPIRED')
AND khl.id = stm.khr_id
AND khl.deal_type IS NOT NULL
AND khs.code = khr.sts_code
-- AND khs.ste_code = 'ACTIVE'
--Added TERMINATED, EXPIRED statuses by bkatraga for bug 7120711
AND khs.ste_code IN ('ACTIVE','TERMINATED','EXPIRED')
--AND kle.id (+)= stm.kle_id
--AND kls.code (+)= kle.sts_code
--AND NVL (kls.ste_code, 'ACTIVE') = 'ACTIVE'
AND khr.ID = p_lk_khr_id
-- Bug 4550607
AND ste1.id = ste.sel_id
AND khl.id= khr.id
AND ste1.date_billed is not null
-- End Bug 4550607
--Added by bkatraga for bug 6983321
AND pl.khr_id = p_ia_id
AND pl.id = plcont.pol_id
AND plcont.khr_id = p_lk_khr_id
AND plcont.STATUS_CODE = 'ACTIVE'
AND plcont.stm_id = stm.stm_id
AND (trunc(ste.stream_element_date) <= trunc(plcont.streams_to_date) OR
plcont.streams_to_date IS NULL)
--end bkatraga
ORDER BY 1, 2, 3;
SELECT
CLET.ID TOP_LINE_ID,
CLET.cust_acct_id,
CLET.bill_to_site_use_id,
KLET.pay_investor_event,
KLET.pay_investor_frequency,
KLET.date_pay_investor_start,
KLET.pay_investor_remittance_days
FROM OKL_K_HEADERS_FULL_V KHR,
OKL_K_LINES KLET,
OKC_K_LINES_B CLET,
OKC_LINE_STYLES_B LSET
WHERE KHR.ID = p_ia_id
AND KLET.ID = CLET.ID
AND KHR.ID = CLET.DNZ_CHR_ID
AND CLET.LSE_ID = LSET.ID
AND LSET.LTY_CODE = 'INVESTMENT'
ORDER BY 1;
SELECT ARAPP.receivable_application_id,
ARAPP.cash_receipt_id,
ARAPP.LINE_APPLIED AMOUNT_APPLIED,
ARAPP.apply_date,
ARAPP.applied_customer_trx_id,
PMTSCH.trx_number,
PMTSCH.trx_date,
PMTSCH.amount_due_original,
PMTSCH.amount_due_remaining,
TLD.TLD_ID TLD_ID,
TLD.LINE_amount AMOUNT
FROM
okl_bpd_tld_ar_lines_v TLD,
AR_PAYMENT_SCHEDULES_ALL PMTSCH,
AR_RECEIVABLE_APPLICATIONS_ALL ARAPP,
ra_Customer_trx_Lines_All cUst_trx_Lines ,
ar_Activity_Details arl
WHERE
TLD.TLD_ID = p_tld_id AND
PMTSCH.customer_trx_id = TLD.customer_trx_id AND
ARAPP.LINE_APPLIED > 0 AND
ARAPP.applied_payment_schedule_id = PMTSCH.payment_schedule_id AND
PMTSCH.class = 'INV' AND
NOT EXISTS (
SELECT '1'
FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay
WHERE pay.receivable_application_id = ARAPP.receivable_application_id AND
pay.investor_agreement_id = p_inv_agr_id AND
pay.investor_line_id = p_inv_agr_line_id AND
pay.TLD_ID = TLD.TLD_ID) AND
TLD.Customer_trx_Line_Id = cUst_trx_Lines.Customer_trx_Line_Id AND cUst_trx_Lines.Line_Type = 'LINE' AND
ARAPP.Receivable_Application_Id = arl.Source_Id AND arl.Source_Table = 'RA' AND arl.Customer_trx_Line_Id = cUst_trx_Lines.Customer_trx_Line_Id AND cUst_trx_Lines.Line_Type = 'LINE'
AND PMTSCH.Payment_Schedule_Id = ARAPP.Applied_Payment_Schedule_Id ;*/
SELECT ARAPP.receivable_application_id,
ARAPP.cash_receipt_id,
ARAPP.LINE_APPLIED AMOUNT_APPLIED,
ARAPP.apply_date,
ARAPP.applied_customer_trx_id,
PMTSCH.trx_number,
PMTSCH.trx_date,
PMTSCH.amount_due_original,
PMTSCH.amount_due_remaining,
TLD.TLD_ID TLD_ID,
TLD.LINE_amount AMOUNT
FROM
okl_bpd_tld_ar_lines_v TLD,
AR_PAYMENT_SCHEDULES_ALL PMTSCH,
AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
WHERE
TLD.TLD_ID = p_tld_id AND
PMTSCH.customer_trx_id = TLD.customer_trx_id AND
ARAPP.LINE_APPLIED > 0 AND
ARAPP.applied_payment_schedule_id = PMTSCH.payment_schedule_id AND
PMTSCH.class = 'INV' AND
PMTSCH.customer_trx_id = TLD.customer_trx_id AND -- cklee 06/25/08
NOT EXISTS (
SELECT '1'
FROM OKL_INVESTOR_PAYOUT_SUMMARY_B pay
WHERE pay.receivable_application_id = ARAPP.receivable_application_id AND
pay.investor_agreement_id = p_inv_agr_id AND
pay.investor_line_id = p_inv_agr_line_id AND
pay.TLD_ID = TLD.TLD_ID);
SELECT RECEIPT_NUMBER
FROM ar_cash_receipts_all
WHERE cash_receipt_id = p_cash_receipt_id;
SELECT trx_number
FROM ra_customer_trx_all
WHERE customer_trx_id = p_app_trx_id;
SELECT PMTSCH.amount_due_original
FROM okl_bpd_tld_ar_lines_v TLD,
AR_PAYMENT_SCHEDULES_ALL PMTSCH
WHERE TLD.TLD_ID = p_tld_id AND
--end:| 09-Mar-2007 cklee code fixed to refer to proper FK
PMTSCH.customer_trx_id = TLD.customer_trx_id AND
PMTSCH.class = 'INV';
l_update_flag VARCHAR2(1);
SELECT
C.CODE_COMBINATION_ID,
C.AE_LINE_TYPE,
C.CRD_CODE,
C.ACCOUNT_BUILDER_YN,
C.PERCENTAGE
FROM OKL_AE_TEMPLATES A,
OKL_PRODUCTS_V B,
OKL_AE_TMPT_LNES C
WHERE A.aes_id = b.aes_id AND
A.start_date <= p_payout_date AND
A.memo_yn = 'N' AND
(A.end_date IS NULL OR
A.end_date >= p_payout_date ) AND
b.id = p_pdt_id AND
a.sty_id = p_sty_id AND
a.try_id = p_try_id AND
C.avl_id = A.id AND
C.CRD_CODE = p_cr_dr_flag;
SELECT tld_Id
FROM okl_bpd_tld_ar_lines_v
WHERE sel_id = p_ref_sel_id
AND CUSTOMER_TRX_ID IS NOT NULL;
SELECT STM.STY_ID
FROM OKL_STRM_ELEMENTS SEL,
OKL_STREAMS STM
WHERE SEL.ID = p_ref_sel_id
AND SEL.STM_ID = STM.ID;
SELECT
KLES.percent_stake
FROM OKL_K_LINES KLES,
OKC_K_LINES_B CLES,
OKC_LINE_STYLES_B LSES
WHERE CLES.cle_id = p_top_line_id
AND KLES.stream_type_subclass = p_sty_subclass
AND KLES.ID = CLES.ID
AND CLES.LSE_ID = LSES.ID
AND LSES.LTY_CODE = 'REVENUE_SHARE';
SELECT CR_DR_FLAG,
CODE_COMBINATION_ID,
SOURCE_ID,
AMOUNT,
PERCENTAGE,
NVL(COMMENTS,'-99') COMMENTS
FROM okl_trns_acc_dstrs
WHERE source_id = p_source_id
AND source_table = p_source_table
--fmiao bug 5079244
ORDER BY CR_DR_FLAG;
select RULE_INFORMATION1
from okc_rule_groups_v rgp,
okc_rules_b rul
where rgp.id = rul.rgp_id
and rgp.dnz_chr_id = p_inv_agr_id
and rul.RULE_INFORMATION_CATEGORY = 'LASEAC'
and rgp.RGD_CODE = 'LASEAC';
SELECT 'Y'
FROM dual
WHERE EXISTS
( SELECT 1
FROM OKL_POOLS pool, okl_pool_contents_v poc, okl_strm_type_v sty
WHERE pool.khr_id = p_khr_id
AND pool.id = poc.pol_id
AND poc.sty_id = sty.id
AND sty.stream_type_purpose = 'RESIDUAL_VALUE'
AND poc.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE); --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
INSERT INTO okl_investor_payout_summary_b
( ID,
OBJECT_VERSION_NUMBER,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
INVESTOR_AGREEMENT_ID,
INVESTOR_LINE_ID,
TLD_ID,
RECEIVABLE_APPLICATION_ID,
ORG_ID
)
VALUES
(
l_idh_id,
1,
Fnd_Global.USER_ID,
SYSDATE,
Fnd_Global.USER_ID,
SYSDATE,
Fnd_Global.LOGIN_ID,
inv_lease_k_rec.Investor_Agreement_id,
share_rec.TOP_LINE_ID,
rcpts_rec.tld_id,
rcpts_rec.receivable_application_id,
l_org_id
);
UPDATE okl_trx_ap_invoices_b
SET trx_status_code = 'ERROR'
WHERE Id = tld_error_log_table(i).tap_id;
UPDATE okl_strm_elements
SET date_billed = SYSDATE
WHERE id = tld_succ_log_table(i).proc_sel_id;
UPDATE OKL_TXD_AR_LN_DTLS_B
SET investor_disb_status = 'PROCESSED'
WHERE sel_id = inv_disb_rec.ref_sel_id;
UPDATE okl_strm_elements
SET date_billed = SYSDATE
WHERE id = tld_succ_log_table(i).proc_sel_id;
UPDATE OKL_TXD_AR_LN_DTLS_B
SET investor_disb_status = 'PROCESSED'
WHERE sel_id = inv_disb_rec.ref_sel_id;
UPDATE okl_strm_elements
SET date_billed = SYSDATE--l_date_billed_tbl(indx);
UPDATE OKL_TXD_AR_LN_DTLS_B
SET investor_disb_status = 'PROCESSED'
WHERE sel_id = l_inv_ele_id_tbl(indx)
and khr_id =inv_lease_k_rec.khr_id;
UPDATE OKL_TXD_AR_LN_DTLS_B
SET investor_disb_status = 'PARTIAL'
WHERE sel_id = l_inv_prtl_id_tbl(indx)
and khr_id =inv_lease_k_rec.khr_id;
UPDATE okl_strm_elements
SET date_billed = SYSDATE
WHERE id = l_strm_ele_id_tbl(indx);
UPDATE OKL_TXD_AR_LN_DTLS_B
SET investor_disb_status = 'PROCESSED'
WHERE sel_id = l_inv_ele_id_tbl(indx)
and khr_id = inv_lease_k_rec.khr_id;
UPDATE OKL_TXD_AR_LN_DTLS_B
SET investor_disb_status = 'PARTIAL'
WHERE sel_id = l_inv_prtl_id_tbl(indx)
and khr_id =inv_lease_k_rec.khr_id;