APPS.OKS_BILL_REC_PUB dependencies on OKS_BILL_TXN_LINES

Line 385: SELECT txn.bill_instance_number from oks_bill_txn_lines txn

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

Line 2406: FROM OKS_BILL_TXN_LINES txn

2402: WHERE ID = p_bcl_id_new;
2403:
2404: Cursor cur_billinstance_sum (p_bcl_id IN NUMBER) is
2405: SELECT bill_instance_number ,bsl_id
2406: FROM OKS_BILL_TXN_LINES txn
2407: WHERE bcl_id = p_bcl_id
2408: AND bsl_id is null;
2409:
2410: Cursor cur_billinstance_dtl (p_bcl_id IN NUMBER,

Line 2413: FROM OKS_BILL_TXN_LINES txn

2409:
2410: Cursor cur_billinstance_dtl (p_bcl_id IN NUMBER,
2411: p_cle_id IN NUMBER) is
2412: SELECT bill_instance_number ,bsl_id
2413: FROM OKS_BILL_TXN_LINES txn
2414: ,OKS_BILL_SUB_LINES bsl
2415: WHERE txn.bcl_id = p_bcl_id
2416: AND bsl.cle_id = p_cle_id
2417: AND bsl.id = txn.bsl_id;

Line 3588: SELECT txn.bill_instance_number from oks_bill_txn_lines txn

3584:
3585: -- Bug Fix 5236358 Hari --
3586:
3587: Cursor bill_instance_csr (p_bcl_id in NUMBER) is
3588: SELECT txn.bill_instance_number from oks_bill_txn_lines txn
3589: WHERE bcl_id = p_bcl_id;
3590:
3591:
3592: i NUMBER;