APPS.OKS_BILL_REC_PUB dependencies on OKS_BILL_TXN_LINES

Line 382: SELECT txn.bill_instance_number from oks_bill_txn_lines txn

378: AND mtl.organization_id = hdr.inv_organization_id;
379:
380: Cursor bill_instance_csr (p_bcl_id in NUMBER,
381: p_bsl_id in NUMBER) is
382: SELECT txn.bill_instance_number from oks_bill_txn_lines txn
383: WHERE bcl_id = p_bcl_id
384: AND nvl(bsl_id,-1) = decode(bsl_id,NULL,-1,p_bsl_id);
385: /*nvl condition added in above to take care of summary billing records.
386: in case of summary billing bsl_id is null in above table*/

Line 2392: FROM OKS_BILL_TXN_LINES txn

2388: WHERE ID = p_bcl_id_new;
2389:
2390: Cursor cur_billinstance_sum (p_bcl_id IN NUMBER) is
2391: SELECT bill_instance_number ,bsl_id
2392: FROM OKS_BILL_TXN_LINES txn
2393: WHERE bcl_id = p_bcl_id
2394: AND bsl_id is null;
2395:
2396: Cursor cur_billinstance_dtl (p_bcl_id IN NUMBER,

Line 2399: FROM OKS_BILL_TXN_LINES txn

2395:
2396: Cursor cur_billinstance_dtl (p_bcl_id IN NUMBER,
2397: p_cle_id IN NUMBER) is
2398: SELECT bill_instance_number ,bsl_id
2399: FROM OKS_BILL_TXN_LINES txn
2400: ,OKS_BILL_SUB_LINES bsl
2401: WHERE txn.bcl_id = p_bcl_id
2402: AND bsl.cle_id = p_cle_id
2403: AND bsl.id = txn.bsl_id;

Line 3562: SELECT txn.bill_instance_number from oks_bill_txn_lines txn

3558:
3559: -- Bug Fix 5236358 Hari --
3560:
3561: Cursor bill_instance_csr (p_bcl_id in NUMBER) is
3562: SELECT txn.bill_instance_number from oks_bill_txn_lines txn
3563: WHERE bcl_id = p_bcl_id;
3564:
3565:
3566: i NUMBER;