APPS.OKS_BILL_UTIL_PUB dependencies on OKS_BILL_SUB_LINES

Line 902: (select 1 from oks_bill_sub_lines bsl

898: AND le.rul_id = str.id
899: AND le.date_completed IS NULL
900: AND trunc(nvl(le.date_to_interface,sysdate)) <= trunc(p_date)
901: AND not exists
902: (select 1 from oks_bill_sub_lines bsl
903: where le.cle_id = bsl.cle_id
904: and trunc(le.date_start) >= trunc(bsl.date_billed_from)
905: and trunc(le.date_end) <= trunc(bsl.date_billed_to))
906: ORDER BY le.date_start;

Line 938: FROM oks_bill_sub_lines

934:
935:
936: Cursor l_bsl_csr(p_cle_id IN NUMBER) is
937: SELECT max(date_billed_to)
938: FROM oks_bill_sub_lines
939: WHERE cle_id = p_cle_id;
940:
941: level_element_rec L_CSR_LEVEL_ELEMENTS%ROWTYPE;
942: i NUMBER := 1;

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 3977: FROM OKS_BILL_SUB_LINES

3973: WHERE cle_id = p_cp_id;
3974:
3975: CURSOR L_GET_BSL_CSR ( P_ID NUMBER ) IS
3976: SELECT 1
3977: FROM OKS_BILL_SUB_LINES
3978: WHERE CLE_ID = P_ID ;
3979:
3980: l_get_itm_uom_rec l_get_itm_uom_csr%ROWTYPE;
3981: L_GET_COVERED_LEVELS_REC L_GET_COVERED_LEVELS_CSR%ROWTYPE ;

Line 4015: --HERE ITS CALLS THE PROCEDURE TO INSERT LINES INTO OKS_BILL_SUB_LINES.

4011: L_BSLV_REC_IN.DATE_BILLED_TO := L_GET_COVERED_LEVELS_REC.COVERED_LEVEL_END_DATE;
4012: L_BSLV_REC_IN.AMOUNT := L_GET_COVERED_LEVELS_REC.PRICE_NEGOTIATED;
4013: L_BSLV_REC_IN.AVERAGE := 0;
4014: ------------------------------------------------------------------------------
4015: --HERE ITS CALLS THE PROCEDURE TO INSERT LINES INTO OKS_BILL_SUB_LINES.
4016: ------------------------------------------------------------------------------
4017: OKS_BILLSUBLINE_PUB.INSERT_BILL_SUBLINE_PUB
4018: (
4019: P_API_VERSION => 1.0,

Line 4230: From oks_bill_sub_lines

4226: Where cle_id = p_id;
4227:
4228: Cursor l_bill_sub_line_csr IS
4229: Select Trunc(Max(date_billed_to))
4230: From oks_bill_sub_lines
4231: Where cle_id = p_id;
4232:
4233: l_billed_upto Date := Null;
4234: Begin

Line 4350: FROM oks_bill_sub_lines

4346: bcl_id, amount, average, date_to_interface,
4347: attribute_category,attribute1,attribute2,attribute3,attribute4 ,
4348: attribute5,attribute6,attribute7,attribute8,attribute9,
4349: attribute10,attribute11,attribute12,attribute13,attribute14,attribute15
4350: FROM oks_bill_sub_lines
4351: WHERE cle_id = p_old_cp_id
4352: ORDER BY date_billed_from;
4353:
4354: CURSOR l_bsd_csr (p_bsl_id NUMBER)IS

Line 4467: UPDATE oks_bill_sub_lines

4463: RAISE G_EXCEPTION_HALT_VALIDATION;
4464: END IF;
4465:
4466: ---update old bsl record
4467: UPDATE oks_bill_sub_lines
4468: SET amount = nvl(amount,0) - nvl(p_new_cp_lvl_tbl(l_index).amount, 0)
4469: WHERE id = l_bsl_rec.id;
4470:
4471: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN

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: