APPS.OKS_BILL_UTIL_PUB dependencies on OKS_BILL_CONT_LINES

Line 931: From oks_bill_cont_lines

927: ********/
928: /*
929: Cursor l_bcl_csr(p_cle_id IN NUMBER) is
930: Select max(date_billed_to)
931: From oks_bill_cont_lines
932: WHERE cle_id = p_cle_id;
933: */
934:
935:

Line 2237: FROM Oks_bill_cont_lines bcl, Oks_bill_sub_lines bsl

2233: IS
2234:
2235: CURSOR l_credit_amt_csr IS
2236: SELECT nvl(SUM(bsl.amount),0) tot_credit_amt
2237: FROM Oks_bill_cont_lines bcl, Oks_bill_sub_lines bsl
2238: WHERE bsl.Cle_id = p_cp_line_id
2239: AND bcl.id = bsl.bcl_id
2240: AND bcl.bill_action = 'TR';
2241:

Line 3789: FROM OKS_BILL_CONT_LINES BCL

3785: SELECT BCL.ID ,
3786: TRUNC(BCL.DATE_BILLED_FROM) DATE_BILLED_FROM ,
3787: TRUNC(BCL.DATE_BILLED_TO) DATE_BILLED_TO,
3788: AMOUNT BCL_AMOUNT
3789: FROM OKS_BILL_CONT_LINES BCL
3790: WHERE BCL.CLE_ID = P_LINE_ID ;
3791:
3792: CURSOR l_hdr_csr(p_hdr_id NUMBER) IS
3793: SELECT currency_code

Line 4109: FROM OKS_BILL_CONT_LINES

4105: WHERE id = p_line_id ;
4106:
4107: CURSOR l_billed_amt_csr IS
4108: SELECT nvl(SUM(AMOUNT),0) tot_amt
4109: FROM OKS_BILL_CONT_LINES
4110: WHERE cle_id = p_line_id ;
4111:
4112: CURSOR l_tot_Qty_csr IS
4113: SELECT SUM(QUANTITY) qty

Line 4215: From oks_bill_cont_lines

4211: p_level IN Varchar2
4212: ) Return Date IS
4213: Cursor l_hdr_bill_cont_lines_csr IS
4214: Select Trunc(Max(date_billed_to))
4215: From oks_bill_cont_lines
4216: Where cle_id In
4217: ( Select id
4218: From okc_k_lines_b
4219: Where dnz_chr_id = p_id

Line 4225: From oks_bill_cont_lines

4221: );
4222:
4223: Cursor l_bill_cont_line_csr Is
4224: Select Trunc(Max(date_billed_to))
4225: From oks_bill_cont_lines
4226: Where cle_id = p_id;
4227:
4228: Cursor l_bill_sub_line_csr IS
4229: Select Trunc(Max(date_billed_to))

Line 4727: FROM oks_bill_sub_lines bsl, oks_bill_cont_lines bcl

4723:
4724:
4725: CURSOR l_bsl_csr (p_cp_id NUMBER) IS
4726: SELECT max(bsl.date_billed_to) max_billed_to , nvl(SUM(bsl.amount),0) bill_amt
4727: FROM oks_bill_sub_lines bsl, oks_bill_cont_lines bcl
4728: WHERE bsl.cle_id = p_cp_id
4729: AND bsl.bcl_id = bcl.id
4730: AND bcl.bill_action = 'RI';
4731: