APPS.OKS_BILLING_PUB dependencies on OKS_BILL_CONT_LINES

Line 256: FROM oks_bill_cont_lines bcl ,

252:
253: Cursor l_date_csr Is
254: SELECT Min(bsl.DATE_BILLED_FROM)
255: ,Max(bsl.DATE_BILLED_TO)
256: FROM oks_bill_cont_lines bcl ,
257: oks_bill_sub_lines bsl
258: WHERE bsl.cle_id = p_cle_id
259: AND bsl.bcl_id = bcl.id
260: AND bcl.bill_action <> 'AVG';

Line 264: FROM oks_bill_cont_lines bcl,

260: AND bcl.bill_action <> 'AVG';
261:
262: Cursor l_tot_csr Is
263: SELECT NVL(Sum(NVL(bsd.Result,0)),0)
264: FROM oks_bill_cont_lines bcl,
265: oks_bill_sub_lines bsl,
266: oks_bill_sub_line_dtls bsd
267: WHERE bsl.cle_id = p_cle_id
268: AND bsl.bcl_id = bcl.id

Line 1485: Delete from OKS_BILL_CONT_LINES

1481: Delete from OKS_BILL_SUB_LINES
1482: where id in
1483: (select bsl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1484:
1485: Delete from OKS_BILL_CONT_LINES
1486: where id in
1487: (select usg_bcl_id from oks_usg_qp_call_tbl where line_id=Nvl(p_line_id,LINE_ID) and dnz_chr_id=p_dnz_chr_id);
1488:
1489: UPDATE oks_level_elements

Line 7000: oks_bill_cont_lines bcl,

6996: abs(bsl.amount) bsl_amount,
6997: line.lse_id bcl_lse_id
6998: FROM okc_k_headers_b hdr,
6999: oks_bill_sub_lines bsl,
7000: oks_bill_cont_lines bcl,
7001: okc_k_lines_b line
7002: WHERE line.id = bcl.cle_id
7003: AND hdr.id = line.dnz_chr_id
7004: AND hdr.id = nvl(p_contract_hdr_id,hdr.id) --Full Table Scan due to nvl condition

Line 7026: oks_bill_cont_lines bcl,

7022: abs(bsl.amount) bsl_amount,
7023: line.lse_id bcl_lse_id
7024: FROM okc_k_headers_b hdr,
7025: oks_bill_sub_lines bsl,
7026: oks_bill_cont_lines bcl,
7027: okc_k_lines_b line
7028: WHERE line.id = bcl.cle_id
7029: AND hdr.id = line.dnz_chr_id
7030: AND hdr.id = p_contract_hdr_id

Line 7050: oks_bill_cont_lines bcl,

7046: abs(bsl.amount) bsl_amount,
7047: line.lse_id bcl_lse_id
7048: FROM okc_k_headers_b hdr,
7049: oks_bill_sub_lines bsl,
7050: oks_bill_cont_lines bcl,
7051: okc_k_lines_b line
7052: WHERE line.id = bcl.cle_id
7053: AND hdr.id = line.dnz_chr_id
7054: AND hdr.scs_code = nvl(p_category,hdr.scs_code)

Line 7114: UPDATE oks_bill_cont_lines bcl

7110: To avoid process these records bill_action = 'TR' condition is added
7111: in below where clause
7112: */
7113:
7114: UPDATE oks_bill_cont_lines bcl
7115: SET bcl.btn_id = NULL
7116: WHERE bcl.btn_id = -44
7117: AND bcl.bill_Action = 'TR'
7118: AND EXISTS

Line 7157: UPDATE oks_bill_cont_lines bcl

7153: To avoid process these records bill_action = 'TR' condition is added
7154: in below where clause
7155: */
7156:
7157: UPDATE oks_bill_cont_lines bcl
7158: SET bcl.btn_id = NULL
7159: WHERE bcl.btn_id = -44
7160: AND bcl.bill_Action = 'TR'
7161: AND EXISTS

Line 7181: UPDATE oks_bill_cont_lines bcl

7177: --To avoid process these records bill_action = 'TR' condition is added
7178: --in below where clause
7179:
7180:
7181: UPDATE oks_bill_cont_lines bcl
7182: SET bcl.btn_id = NULL
7183: WHERE bcl.btn_id = -44
7184: AND bcl.bill_Action = 'TR'
7185: AND EXISTS