eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_BILL_REC_PUB dependencies on OKS_BILL_SUB_LINES

Line 272: oks_bill_sub_lines bsl

268: ,line.price_negotiated cov_price_negotiated
269: FROM
270: okc_k_lines_b line,
271: oks_bill_cont_lines bcl,
272: oks_bill_sub_lines bsl
273: WHERE bcl.Cle_id = p_top_line_id
274: AND bsl.cle_id = nvl(p_cov_line_id,bsl.cle_id)
275: AND bcl.id = bsl.bcl_id
276: AND bcl.bill_action = 'RI'

Line 398: FROM oks_bill_sub_lines

394: AND l_termination_date between lvl.date_start and lvl.date_end;
395:
396: Cursor avg_csr_bsl_amt(p_cle_id IN NUMBER, p_date_from IN DATE) IS
397: SELECT sum(amount)
398: FROM oks_bill_sub_lines
399: WHERE cle_id = p_cle_id
400: AND date_billed_from = p_date_from;
401:
402: SUBTYPE l_bclv_tbl_type_in is OKS_bcl_PVT.bclv_tbl_type;

Line 1104: oks_bill_sub_lines bsl

1100: sum(bsl.amount) ,
1101: max(bsl.date_billed_From),
1102: max(bsl.date_billed_to)
1103: FROM oks_bill_sub_line_dtls bsd,
1104: oks_bill_sub_lines bsl
1105: WHERE bsl.cle_id = p_cle_id
1106: AND bsd.bsl_id = bsl.id;
1107:
1108:

Line 1117: oks_bill_sub_lines bsl,

1113: bsl.date_billed_to,
1114: bsl.amount,
1115: bsd.result
1116: FROM oks_bill_cont_lines bcl,
1117: oks_bill_sub_lines bsl,
1118: oks_bill_sub_line_dtls bsd
1119: WHERE bcl.id = bsl.bcl_id
1120: AND bsl.cle_id = p_cle_id
1121: AND bsd.bsl_id = bsl.id

Line 1322: FROM oks_bill_sub_lines bsl,

1318:
1319: Cursor sub_line_billed_cur (p_id IN NUMBER) is
1320: SELECT bsl.id ,rline.TERMN_METHOD ,bcl.cle_id,
1321: rline.usage_type, rline.usage_period
1322: FROM oks_bill_sub_lines bsl,
1323: oks_bill_cont_lines bcl,
1324: oks_k_lines_b rline
1325: WHERE bsl.cle_id = p_id
1326: AND bsl.bcl_id = bcl.id

Line 1333: FROM oks_bill_sub_lines

1329:
1330:
1331: Cursor tot_sub_line_billed( p_cle_id IN NUMBER) is
1332: SELECT sum(amount)
1333: FROM oks_bill_sub_lines
1334: WHERE cle_id = p_cle_id;
1335:
1336:
1337: Cursor tot_line_billed( p_cle_id IN NUMBER) is

Line 1938: oks_bill_sub_lines bsl,

1934: Cursor get_future_period_amount is
1935: SELECT nvl(sum(bsl.amount),0) amount
1936: FROM
1937: okc_k_lines_b okl2,
1938: oks_bill_sub_lines bsl,
1939: oks_bill_cont_lines bcl,
1940: okc_k_lines_b okl1
1941: WHERE okl1.id = p_line_id
1942: AND bcl.cle_id = okl1.id

Line 1952: oks_bill_sub_lines bsl

1948: Cursor get_future_prd_amt_covlvl is
1949: SELECT nvl(sum(bsl.amount),0) amount
1950: FROM
1951: okc_k_lines_b okl,
1952: oks_bill_sub_lines bsl
1953: WHERE okl.id = p_line_id
1954: AND bsl.cle_id = okl.id
1955: AND okl.date_terminated is NULL
1956: AND trunc(bsl.date_billed_from) > trunc(p_terminate_date);

Line 1966: oks_bill_sub_lines bsl,

1962: okl.start_date start_date,
1963: okl.end_date end_date,
1964: okl.id id
1965: FROM
1966: oks_bill_sub_lines bsl,
1967: okc_k_lines_b okl
1968: WHERE okl.id = p_line_id
1969: AND okl.id = bsl.cle_id
1970: AND okl.date_terminated is null

Line 1983: oks_bill_sub_lines bsl,

1979: okl1.end_date end_date,
1980: okl1.id id
1981: FROM
1982: okc_k_lines_b okl2,
1983: oks_bill_sub_lines bsl,
1984: oks_bill_cont_lines bcl,
1985: okc_k_lines_b okl1
1986: WHERE okl1.id = p_line_id
1987: AND bcl.cle_id = okl1.id

Line 2318: FROM oks_bill_sub_lines bsl,

2314: ,bsl.Attribute12
2315: ,bsl.Attribute13
2316: ,bsl.Attribute14
2317: ,bsl.Attribute15
2318: FROM oks_bill_sub_lines bsl,
2319: okc_k_lines_b okl
2320: WHERE bcl_id = id_in
2321: AND bsl.cle_id = okl.id
2322: AND okl.date_cancelled is null --LLC BUG FIX 4742661

Line 2400: ,OKS_BILL_SUB_LINES bsl

2396: Cursor cur_billinstance_dtl (p_bcl_id IN NUMBER,
2397: p_cle_id IN NUMBER) is
2398: SELECT bill_instance_number ,bsl_id
2399: FROM OKS_BILL_TXN_LINES txn
2400: ,OKS_BILL_SUB_LINES bsl
2401: WHERE txn.bcl_id = p_bcl_id
2402: AND bsl.cle_id = p_cle_id
2403: AND bsl.id = txn.bsl_id;
2404:

Line 3490: FROM oks_bill_sub_lines bsl

3486: **************************************************************/
3487:
3488: Cursor bsl_cur (p_id in number) is
3489: SELECT bsl.*
3490: FROM oks_bill_sub_lines bsl
3491: WHERE bsl.bcl_id = p_id;
3492:
3493: Cursor bsd_cur (p_id in number) is
3494: Select * from oks_bill_sub_line_dtls

Line 4119: Select bsl.id from oks_bill_sub_lines bsl,

4115: where cle_id = p_id
4116: and bill_action = 'RI';
4117:
4118: Cursor sub_line_billed_cur (p_id IN NUMBER) is
4119: Select bsl.id from oks_bill_sub_lines bsl,
4120: oks_bill_cont_lines bcl
4121: where bsl.cle_id = p_id
4122: and bsl.bcl_id = bcl.id
4123: and bcl.bill_action = 'RI';

Line 4136: from oks_bill_sub_lines

4132: where id = p_bcl_id;
4133:
4134: Cursor bsl_amount (p_bsl_id in number) is
4135: Select nvl(amount,0),cle_id
4136: from oks_bill_sub_lines
4137: where id = p_bsl_id;
4138:
4139: Cursor sub_line_tax(p_sub_line_id in number ) is
4140: Select tax_amount

Line 4147: , oks_bill_sub_lines bsl

4143:
4144: CURSOR l_line_max_bill_date( p_line_id in NUMBER ) is
4145: SELECT max(bsl.date_billed_to) max_bill_date
4146: FROM oks_bill_cont_lines bcl
4147: , oks_bill_sub_lines bsl
4148: WHERE bcl.cle_id = p_line_id
4149: AND bcl.bill_action = 'RI'
4150: AND bcl.id = bsl.bcl_id ;
4151:

Line 4218: oks_bill_sub_lines bsl

4214:
4215: Cursor avg_bcl_amount_partial (p_cle_id in number) is
4216: Select sum(bsl.amount)
4217: from oks_bill_cont_lines bcl,
4218: oks_bill_sub_lines bsl
4219: where bcl.cle_id = p_cle_id
4220: and bsl.bcl_id = bcl.id
4221: and bcl.bill_action <> 'TR'
4222: and trunc(bcl.date_billed_from) >= trunc(p_termination_date);

Line 4227: oks_bill_sub_lines bsl

4223:
4224: Cursor avg_bcl_amount_full (p_cle_id in number) is
4225: Select sum(bsl.amount)
4226: from oks_bill_cont_lines bcl,
4227: oks_bill_sub_lines bsl
4228: where bcl.cle_id = p_cle_id
4229: and bsl.bcl_id = bcl.id
4230: and bcl.bill_action <> 'TR';
4231:

Line 4239: oks_bill_sub_lines bsl

4235: ((trunc(bsl.date_billed_to) - trunc(p_termination_date) + 1) * bsl.amount) /
4236: (trunc(bsl.date_billed_to) - trunc(bsl.date_billed_from) + 1) ,bsl.amount )),0)
4237: -- nvl(sum(bsl.amount),0)
4238: from oks_bill_cont_lines bcl,
4239: oks_bill_sub_lines bsl
4240: where bcl.cle_id = p_cle_id
4241: and bsl.bcl_id = bcl.id
4242: and bcl.bill_action <> 'TR'
4243: and trunc(bsl.date_billed_from) >= trunc(p_termination_date)

Line 4251: oks_bill_sub_lines bsl

4247: Select nvl(sum(decode(sign(trunc(bsl.date_billed_from) - trunc(p_termination_date)) ,-1,
4248: ((trunc(bsl.date_billed_to) - trunc(p_termination_date) + 1) * bsl.amount) /
4249: (trunc(bsl.date_billed_to) - trunc(bsl.date_billed_from) + 1) ,bsl.amount )),0)
4250: from oks_bill_cont_lines bcl,
4251: oks_bill_sub_lines bsl
4252: where bcl.cle_id = p_cle_id
4253: and bsl.bcl_id = bcl.id
4254: and bcl.bill_action <> 'TR'
4255: and trunc(bsl.date_billed_from) >= trunc(p_termination_date)

Line 4268: oks_bill_sub_lines bsl,

4264: Select nvl(sum(decode(sign(trunc(bsl.date_billed_from) - trunc(p_termination_date)) ,-1,
4265: ((trunc(bsl.date_billed_to) - trunc(p_termination_date) + 1) * bsl.amount) /
4266: (trunc(bsl.date_billed_to) - trunc(bsl.date_billed_from) + 1) ,bsl.amount )),0)
4267: from oks_bill_cont_lines bcl,
4268: oks_bill_sub_lines bsl,
4269: okc_k_lines_b line
4270: where bsl.bcl_id = bcl.id
4271: and line.id = bcl.cle_id
4272: and bcl.bill_action <> 'TR'

Line 4284: oks_bill_sub_lines bsl,

4280: Select nvl(sum(decode(sign(trunc(bsl.date_billed_from) - trunc(p_termination_date)) ,-1,
4281: ((trunc(bsl.date_billed_to) - trunc(p_termination_date) + 1) * bsl.amount) /
4282: (trunc(bsl.date_billed_to) - trunc(bsl.date_billed_from) + 1) ,bsl.amount )),0)
4283: from oks_bill_cont_lines bcl,
4284: oks_bill_sub_lines bsl,
4285: okc_k_lines_b line
4286: where bsl.bcl_id = bcl.id
4287: and line.id = bcl.cle_id
4288: and bcl.bill_action <> 'TR'

Line 4575: UPDATE oks_bill_sub_lines

4571: l_bsl_credit_amount := l_bsl_credit_amount +
4572: ((-1)*(l_termination_amount - g_credit_amount)) ;
4573: l_bsl_update_id := g_bsl_id;
4574:
4575: UPDATE oks_bill_sub_lines
4576: SET amount = l_bsl_credit_amount
4577: WHERE id = l_bsl_update_id ;
4578:
4579: l_bcl_credit_amount := l_bcl_credit_amount +

Line 4592: UPDATE oks_bill_sub_lines

4588:
4589: l_bsl_credit_amount := l_bsl_credit_amount + (g_credit_amount - l_termination_amount ) ;
4590: l_bsl_update_id := g_bsl_id;
4591:
4592: UPDATE oks_bill_sub_lines
4593: SET amount = l_bsl_credit_amount
4594: WHERE id = l_bsl_update_id;
4595:
4596: l_bcl_credit_amount := l_bcl_credit_amount + (g_credit_amount - l_termination_amount) ;

Line 4662: UPDATE oks_bill_sub_lines

4658: l_bsl_credit_amount := l_bsl_credit_amount +
4659: ((-1)*(l_termination_amount - g_credit_amount)) ;
4660: l_bsl_update_id := g_bsl_id;
4661:
4662: UPDATE oks_bill_sub_lines
4663: SET amount = l_bsl_credit_amount
4664: WHERE id = l_bsl_update_id ;
4665:
4666: l_bcl_credit_amount := l_bcl_credit_amount +

Line 4680: UPDATE oks_bill_sub_lines

4676: l_bsl_credit_amount := l_bsl_credit_amount +
4677: (g_credit_amount - l_termination_amount ) ;
4678: l_bsl_update_id := g_bsl_id;
4679:
4680: UPDATE oks_bill_sub_lines
4681: SET amount = l_bsl_credit_amount
4682: WHERE id = l_bsl_update_id;
4683:
4684: l_bcl_credit_amount := l_bcl_credit_amount +

Line 4718: UPDATE oks_bill_sub_lines

4714: l_bsl_credit_amount := l_bsl_credit_amount +
4715: ((-1)*(l_termination_amount - g_credit_amount)) ;
4716: l_bsl_update_id := g_bsl_id;
4717:
4718: UPDATE oks_bill_sub_lines
4719: SET amount = l_bsl_credit_amount
4720: WHERE id = l_bsl_update_id ;
4721:
4722: l_bcl_credit_amount := l_bcl_credit_amount +

Line 4735: UPDATE oks_bill_sub_lines

4731:
4732: l_bsl_credit_amount := l_bsl_credit_amount + (g_credit_amount - l_termination_amount ) ;
4733: l_bsl_update_id := g_bsl_id;
4734:
4735: UPDATE oks_bill_sub_lines
4736: SET amount = l_bsl_credit_amount
4737: WHERE id = l_bsl_update_id;
4738:
4739: l_bcl_credit_amount := l_bcl_credit_amount + (g_credit_amount - l_termination_amount) ;

Line 5108: UPDATE oks_bill_sub_lines

5104: l_bsl_credit_amount := l_bsl_credit_amount +
5105: ((-1)*(l_termination_amount - g_credit_amount)) ;
5106: l_bsl_update_id := g_bsl_id;
5107:
5108: UPDATE oks_bill_sub_lines
5109: SET amount = l_bsl_credit_amount
5110: WHERE id = l_bsl_update_id ;
5111:
5112: l_bcl_credit_amount := l_bcl_credit_amount +

Line 5184: UPDATE oks_bill_sub_lines

5180: Elsif g_credit_amount > l_termination_amount then
5181: l_bsl_credit_amount := l_bsl_credit_amount + (g_credit_amount - l_termination_amount ) ;
5182: l_bsl_update_id := g_bsl_id;
5183:
5184: UPDATE oks_bill_sub_lines
5185: SET amount = l_bsl_credit_amount
5186: WHERE id = l_bsl_update_id ;
5187:
5188: l_bcl_credit_amount := l_bcl_credit_amount + (g_credit_amount - l_termination_amount) ;

Line 5594: oks_bill_sub_lines bsl

5590: Cursor l_date_csr Is
5591: SELECT Min(bsl.DATE_BILLED_FROM)
5592: ,Max(bsl.DATE_BILLED_TO)
5593: FROM oks_bill_cont_lines bcl ,
5594: oks_bill_sub_lines bsl
5595: WHERE bsl.cle_id = p_cle_id
5596: AND bsl.bcl_id = bcl.id
5597: AND bcl.bill_action = 'RI';
5598:

Line 5602: oks_bill_sub_lines bsl,

5598:
5599: Cursor l_tot_csr Is
5600: SELECT NVL(Sum(NVL(bsd.Result,0)),0)
5601: FROM oks_bill_cont_lines bcl,
5602: oks_bill_sub_lines bsl,
5603: oks_bill_sub_line_dtls bsd
5604: WHERE bsl.cle_id = p_cle_id
5605: AND bsl.bcl_id = bcl.id
5606: AND bcl.bill_action ='RI'

Line 5719: FROM oks_bill_sub_lines

5715: IS
5716: /* ONE is added to count to consider the unbilled current period */
5717: CURSOR billed_period_csr (p_cle_id IN NUMBER) IS
5718: SELECT count(*) + 1
5719: FROM oks_bill_sub_lines
5720: WHERE cle_id = p_cle_id;
5721:
5722: CURSOR total_billed_qty (p_cle_id IN NUMBER) IS
5723: SELECT sum(result)

Line 5725: oks_bill_sub_lines bsl

5721:
5722: CURSOR total_billed_qty (p_cle_id IN NUMBER) IS
5723: SELECT sum(result)
5724: FROM oks_bill_sub_line_dtls bsd,
5725: oks_bill_sub_lines bsl
5726: WHERE bsl.cle_id = p_cle_id
5727: AND bsd.bsl_id = bsl.id;
5728:
5729: CURSOR l_max_date_end (p_cle_id IN NUMBER, p_date IN DATE) IS

Line 6407: ,oks_bill_sub_lines line

6403:
6404: Cursor l_actual_counter_csr(p_cle_id IN NUMBER) Is
6405: SELECT nvl(end_reading,0) qty
6406: FROM Oks_bill_sub_line_dtls ldtl
6407: ,oks_bill_sub_lines line
6408: WHERE line.cle_id = p_cle_id
6409: AND ldtl.bsl_id = line.id
6410: AND nvl(end_reading,0) > 0
6411: AND trunc(date_billed_from) < trunc(p_start_date)

Line 6428: ,oks_bill_sub_lines line

6424:
6425: Cursor l_actual_csr(p_cle_id IN NUMBER) Is
6426: SELECT NVL(sign(ldtl.amount)*Result,0) + nvl(base_reading,0) qty
6427: FROM Oks_bill_sub_line_dtls ldtl
6428: ,oks_bill_sub_lines line
6429: WHERE line.cle_id = p_cle_id
6430: AND ldtl.bsl_id = line.id
6431: ORDER BY date_billed_to desc ;
6432:

Line 6447: ,oks_bill_sub_lines line

6443:
6444: Cursor l_ccr_id_csr Is
6445: SELECT end_reading read,ccr_id,cgr_id
6446: FROM Oks_bill_sub_line_dtls ldtl
6447: ,oks_bill_sub_lines line
6448: WHERE line.cle_id = p_cle_id
6449: AND ldtl.bsl_id = line.id
6450: -- Bug#4730007 nechatur 1-Dec-2005
6451: -- Order By ldtl.id desc;

Line 6520: ,oks_bill_sub_lines line

6516:
6517: Cursor l_actual_term_csr(p_cle_id IN NUMBER) Is
6518: SELECT NVL(sign(ldtl.amount)*Result,0) + nvl(base_reading,0) qty
6519: FROM Oks_bill_sub_line_dtls ldtl
6520: ,oks_bill_sub_lines line
6521: WHERE line.cle_id = p_cle_id
6522: AND ldtl.bsl_id = line.id
6523: AND trunc(date_billed_from) < trunc(p_start_date)
6524: ORDER BY date_billed_to desc;

Line 6984: UPDATE oks_bill_sub_lines

6980: SET amount = nvl(amount,0) + round_amount,
6981: currency_code = l_cur_holder
6982: WHERE id = p_bcl_id;
6983:
6984: UPDATE oks_bill_sub_lines
6985: SET amount = round_amount,
6986: average = 0
6987: WHERE id = p_bsl_id;
6988:

Line 7796: From oks_bill_sub_lines

7792:
7793: CURSOR l_amount_csr(id_in Number)
7794: IS
7795: Select nvl(sum(NVL(amount,0)),0) amount_billed
7796: From oks_bill_sub_lines
7797: Where cle_id = id_in;
7798:
7799: Cursor l_inv_item_csr(p_cle_id Number)
7800: Is

Line 7992: oks_bill_sub_lines_v

7988:
7989: /* The above cursor is for get the billed amount so far.
7990: To support , middle of the contract amount changes.
7991: select sum(amount) into l_amount_billed
7992: oks_bill_sub_lines_v
7993: cle_id = l_covlvl_rec.id;
7994: */
7995:
7996:

Line 8124: oks_bill_sub_lines bsl

8120: Cursor check_term_cur(p_cle_id NUMBER) is
8121: SELECT bsl.id,
8122: bcl.cle_id top_line_id
8123: FROM oks_bill_cont_lines bcl,
8124: oks_bill_sub_lines bsl
8125: WHERE bsl.bcl_id = bcl.id
8126: AND bcl.bill_action = 'TR'
8127: AND bsl.cle_id = p_cle_id;
8128:

Line 8154: SELECT bsl.id FROM oks_bill_sub_lines bsl,

8150: (line1.sts_code = 'HOLD'));
8151:
8152:
8153: Cursor sub_line_billed_cur (p_id IN NUMBER) is
8154: SELECT bsl.id FROM oks_bill_sub_lines bsl,
8155: oks_bill_cont_lines bcl
8156: WHERE bsl.cle_id = p_id
8157: AND bsl.bcl_id = bcl.id
8158: AND bcl.bill_action = 'RI';

Line 8165: Select amount from oks_bill_sub_lines

8161: Select amount from oks_bill_cont_lines
8162: where id = p_bcl_id;
8163:
8164: Cursor bsl_amount (p_bsl_id in number) is
8165: Select amount from oks_bill_sub_lines
8166: where id = p_bsl_id;
8167:
8168: --04-JAN-2006 mchoudha for bug#4738970
8169: --Added this cursor to fetch the ste_code

Line 8183: oks_bill_sub_lines bsl

8179: ((trunc(bsl.date_billed_to) - trunc(p_termination_date) + 1) * bsl.amount) /
8180: (trunc(bsl.date_billed_to) - trunc(bsl.date_billed_from) + 1) ,bsl.amount )),0)
8181: -- nvl(sum(bsl.amount),0)
8182: from oks_bill_cont_lines bcl,
8183: oks_bill_sub_lines bsl
8184: where bcl.cle_id = p_cle_id
8185: and bsl.bcl_id = bcl.id
8186: and bcl.bill_action <> 'TR'
8187: --and trunc(bsl.date_billed_from) >= trunc(p_termination_date)

Line 8196: oks_bill_sub_lines bsl

8192: Select nvl(sum(decode(sign(trunc(bsl.date_billed_from) - trunc(p_termination_date)) ,-1,
8193: ((trunc(bsl.date_billed_to) - trunc(p_termination_date) + 1) * bsl.amount) /
8194: (trunc(bsl.date_billed_to) - trunc(bsl.date_billed_from) + 1) ,bsl.amount )),0)
8195: from oks_bill_cont_lines bcl,
8196: oks_bill_sub_lines bsl
8197: where bcl.cle_id = p_cle_id
8198: and bsl.bcl_id = bcl.id
8199: and bcl.bill_action <> 'TR'
8200: --and trunc(bsl.date_billed_from) >= trunc(p_termination_date)

Line 8329: UPDATE oks_bill_sub_lines

8325: If g_credit_amount < p_override_amount then
8326: l_bsl_credit_amount := l_bsl_credit_amount + ((-1)*(p_override_amount - g_credit_amount)) ;
8327: l_bsl_id := g_bsl_id;
8328:
8329: UPDATE oks_bill_sub_lines
8330: SET amount = l_bsl_credit_amount
8331: WHERE id = l_bsl_id ;
8332:
8333: l_bcl_credit_amount := l_bcl_credit_amount + ((-1)*(p_override_amount - g_credit_amount)) ;

Line 8345: UPDATE oks_bill_sub_lines

8341:
8342: l_bsl_credit_amount := l_bsl_credit_amount + (g_credit_amount - p_override_amount ) ;
8343: l_bsl_id := g_bsl_id;
8344:
8345: UPDATE oks_bill_sub_lines
8346: SET amount = l_bsl_credit_amount
8347: WHERE id = l_bsl_id ;
8348:
8349: l_bcl_credit_amount := l_bcl_credit_amount + (g_credit_amount - p_override_amount) ;

Line 8559: FROM oks_bill_sub_lines

8555:
8556: CURSOR max_date_billed_to_Cur (p_cle_id IN NUMBER)
8557: IS
8558: SELECT max(date_billed_to)
8559: FROM oks_bill_sub_lines
8560: WHERE cle_id = p_cle_id;
8561:
8562: Cursor l_line_csr(p_id in NUMBER) is
8563: SELECT start_date,end_date,sts_code,

Line 8616: Select amount from oks_bill_sub_lines

8612: Select amount from oks_bill_cont_lines
8613: where id = p_bcl_id;
8614:
8615: Cursor bsl_amount (p_bsl_id in number) is
8616: Select amount from oks_bill_sub_lines
8617: where id = p_bsl_id;
8618:
8619: l_bcl_credit_amount NUMBER;
8620: l_bsl_credit_amount NUMBER;

Line 8938: UPDATE oks_bill_sub_lines

8934: If g_credit_amount < p_override_amount then
8935: l_bsl_credit_amount := l_bsl_credit_amount + ((-1)*(p_override_amount - g_credit_amount)) ;
8936: l_bsl_id := g_bsl_id;
8937:
8938: UPDATE oks_bill_sub_lines
8939: SET amount = l_bsl_credit_amount
8940: WHERE id = l_bsl_id ;
8941:
8942: l_bcl_credit_amount := l_bcl_credit_amount + ((-1)*(p_override_amount - g_credit_amount)) ;

Line 8954: UPDATE oks_bill_sub_lines

8950:
8951: l_bsl_credit_amount := l_bsl_credit_amount + (g_credit_amount - p_override_amount ) ;
8952: l_bsl_id := g_bsl_id;
8953:
8954: UPDATE oks_bill_sub_lines
8955: SET amount = l_bsl_credit_amount
8956: WHERE id = l_bsl_id ;
8957:
8958: l_bcl_credit_amount := l_bcl_credit_amount + (g_credit_amount - p_override_amount) ;

Line 9029: ,OKS_BILL_SUB_LINES BSL

9025: CURSOR L_HDR_BILLED_CSR IS
9026: SELECT nvl(SUM(BSL.amount),0) billed
9027: FROM OKC_K_LINES_B OKCL
9028: ,OKS_BILL_CONT_LINES BCL
9029: ,OKS_BILL_SUB_LINES BSL
9030: WHERE OKCL.dnz_chr_id = p_id
9031: AND OKCL.lse_id in ( 7,8,9,10,11,13,25,35,46)
9032: AND OKCL.id = BSL.cle_id
9033: AND BSL.bcl_id = BCL.id

Line 9069: ,OKS_BILL_SUB_LINES BSL

9065: CURSOR l_TOP_LINE_BILLED_CSR IS
9066: SELECT nvl(SUM(BSL.amount),0) billed
9067: FROM OKC_K_LINES_B OKCL
9068: ,OKS_BILL_CONT_LINES BCL
9069: ,OKS_BILL_SUB_LINES BSL
9070: WHERE ( OKCL.cle_id = p_id
9071: OR ( OKCL.ID = p_id and OKCL.lse_id = 46))
9072: AND OKCL.lse_id in ( 7,8,9,10,11,13,25,35,46)
9073: AND OKCL.id = BSL.cle_id

Line 9095: ,OKS_BILL_SUB_LINES BSL

9091:
9092: CURSOR l_SUB_LINE_BILLED_CSR IS
9093: SELECT nvl(SUM(BSL.amount),0) billed
9094: FROM OKS_BILL_CONT_LINES BCL
9095: ,OKS_BILL_SUB_LINES BSL
9096: WHERE BSL.cle_id = p_id
9097: AND BSL.bcl_id = BCL.id
9098: AND BCL.bill_action = 'RI';
9099: l_unbilled NUMBER ;

Line 9177: FROM oks_bill_sub_lines bsl,

9173: WHERE cle_id = p_sub_line_id ;
9174:
9175: CURSOR l_credit_csr(p_sub_line_id in NUMBER ) is
9176: SELECT sum(bsl.amount) suppressed_credit
9177: FROM oks_bill_sub_lines bsl,
9178: oks_bill_cont_lines bcl
9179: WHERE bsl.cle_id = p_sub_line_id
9180: AND bcl.id = bsl.bcl_id
9181: AND btn_id is null

Line 9186: FROM oks_bill_sub_lines bsl,

9182: AND bcl.bill_action = 'TR';
9183:
9184: CURSOR l_suppressed_credit_csr(p_sub_line_id in NUMBER ) is
9185: SELECT sum(bsl.amount) suppressed_credit
9186: FROM oks_bill_sub_lines bsl,
9187: oks_bill_cont_lines bcl
9188: WHERE bsl.cle_id = p_sub_line_id
9189: AND bcl.id = bsl.bcl_id
9190: AND btn_id = -44

Line 9905: FROM oks_bill_sub_lines bsl

9901: IS
9902: SELECT sum(bsl.amount) ,
9903: max(bsl.date_billed_From),
9904: max(bsl.date_billed_to)
9905: FROM oks_bill_sub_lines bsl
9906: WHERE bsl.cle_id = p_cle_id;
9907:
9908: --Cursor to get the billing details for the subline
9909: Cursor bsl_cur (p_cle_id IN NUMBER)

Line 9917: oks_bill_sub_lines bsl,

9913: bsl.date_billed_to,
9914: bsl.amount,
9915: bsd.result
9916: FROM oks_bill_cont_lines bcl,
9917: oks_bill_sub_lines bsl,
9918: oks_bill_sub_line_dtls bsd
9919: WHERE bcl.id = bsl.bcl_id
9920: AND bsl.cle_id = p_cle_id
9921: AND bsd.bsl_id = bsl.id

Line 10367: FROM oks_bill_sub_lines bsl

10363: IS
10364: SELECT sum(bsl.amount) ,
10365: max(bsl.date_billed_From),
10366: max(bsl.date_billed_to)
10367: FROM oks_bill_sub_lines bsl
10368: WHERE bsl.cle_id = p_cle_id;
10369:
10370: CURSOR om_period_csr(p_id IN NUMBER) IS
10371: select oel.service_period,oel.service_duration,