APPS.OKS_BILL_UTIL_PUB dependencies on OKS_BILL_CONT_LINES

Line 965: From oks_bill_cont_lines

961: ********/
962: /*
963: Cursor l_bcl_csr(p_cle_id IN NUMBER) is
964: Select max(date_billed_to)
965: From oks_bill_cont_lines
966: WHERE cle_id = p_cle_id;
967: */
968:
969:

Line 2271: FROM Oks_bill_cont_lines bcl, Oks_bill_sub_lines bsl

2267: IS
2268:
2269: CURSOR l_credit_amt_csr IS
2270: SELECT nvl(SUM(bsl.amount),0) tot_credit_amt
2271: FROM Oks_bill_cont_lines bcl, Oks_bill_sub_lines bsl
2272: WHERE bsl.Cle_id = p_cp_line_id
2273: AND bcl.id = bsl.bcl_id
2274: AND bcl.bill_action = 'TR';
2275:

Line 3824: FROM OKS_BILL_CONT_LINES BCL

3820: SELECT BCL.ID ,
3821: TRUNC(BCL.DATE_BILLED_FROM) DATE_BILLED_FROM ,
3822: TRUNC(BCL.DATE_BILLED_TO) DATE_BILLED_TO,
3823: AMOUNT BCL_AMOUNT
3824: FROM OKS_BILL_CONT_LINES BCL
3825: WHERE BCL.CLE_ID = P_LINE_ID ;
3826:
3827: CURSOR l_hdr_csr(p_hdr_id NUMBER) IS
3828: SELECT currency_code

Line 4235: FROM OKS_BILL_CONT_LINES BCL

4231: SELECT BCL.ID ,
4232: TRUNC(BCL.DATE_BILLED_FROM) DATE_BILLED_FROM ,
4233: TRUNC(BCL.DATE_BILLED_TO) DATE_BILLED_TO,
4234: AMOUNT BCL_AMOUNT
4235: FROM OKS_BILL_CONT_LINES BCL
4236: WHERE BCL.CLE_ID = P_LINE_ID ;
4237: CURSOR l_hdr_csr(p_hdr_id NUMBER) IS
4238: SELECT currency_code
4239: FROM okc_k_headers_b

Line 4603: FROM OKS_BILL_CONT_LINES

4599: WHERE id = p_line_id ;
4600:
4601: CURSOR l_billed_amt_csr IS
4602: SELECT nvl(SUM(AMOUNT),0) tot_amt
4603: FROM OKS_BILL_CONT_LINES
4604: WHERE cle_id = p_line_id ;
4605:
4606: CURSOR l_tot_Qty_csr IS
4607: SELECT SUM(QUANTITY) qty

Line 4709: From oks_bill_cont_lines

4705: p_level IN Varchar2
4706: ) Return Date IS
4707: Cursor l_hdr_bill_cont_lines_csr IS
4708: Select Trunc(Max(date_billed_to))
4709: From oks_bill_cont_lines
4710: Where cle_id In
4711: ( Select id
4712: From okc_k_lines_b
4713: Where dnz_chr_id = p_id

Line 4719: From oks_bill_cont_lines

4715: );
4716:
4717: Cursor l_bill_cont_line_csr Is
4718: Select Trunc(Max(date_billed_to))
4719: From oks_bill_cont_lines
4720: Where cle_id = p_id;
4721:
4722: Cursor l_bill_sub_line_csr IS
4723: Select Trunc(Max(date_billed_to))

Line 5221: FROM oks_bill_sub_lines bsl, oks_bill_cont_lines bcl

5217:
5218:
5219: CURSOR l_bsl_csr (p_cp_id NUMBER) IS
5220: SELECT max(bsl.date_billed_to) max_billed_to , nvl(SUM(bsl.amount),0) bill_amt
5221: FROM oks_bill_sub_lines bsl, oks_bill_cont_lines bcl
5222: WHERE bsl.cle_id = p_cp_id
5223: AND bsl.bcl_id = bcl.id
5224: AND bcl.bill_action = 'RI';
5225: