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 275: oks_bill_sub_lines bsl

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

Line 401: FROM oks_bill_sub_lines

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

Line 1123: oks_bill_sub_lines bsl

1119: sum(bsl.amount) ,
1120: max(bsl.date_billed_From),
1121: max(bsl.date_billed_to)
1122: FROM oks_bill_sub_line_dtls bsd,
1123: oks_bill_sub_lines bsl
1124: WHERE bsl.cle_id = p_cle_id
1125: AND bsd.bsl_id = bsl.id;
1126:
1127:

Line 1136: oks_bill_sub_lines bsl,

1132: bsl.date_billed_to,
1133: bsl.amount,
1134: bsd.result
1135: FROM oks_bill_cont_lines bcl,
1136: oks_bill_sub_lines bsl,
1137: oks_bill_sub_line_dtls bsd
1138: WHERE bcl.id = bsl.bcl_id
1139: AND bsl.cle_id = p_cle_id
1140: AND bsd.bsl_id = bsl.id

Line 1342: FROM oks_bill_sub_lines bsl,

1338:
1339: Cursor sub_line_billed_cur (p_id IN NUMBER) is
1340: SELECT bsl.id ,rline.TERMN_METHOD ,bcl.cle_id,
1341: rline.usage_type, rline.usage_period
1342: FROM oks_bill_sub_lines bsl,
1343: oks_bill_cont_lines bcl,
1344: oks_k_lines_b rline
1345: WHERE bsl.cle_id = p_id
1346: AND bsl.bcl_id = bcl.id

Line 1353: FROM oks_bill_sub_lines

1349:
1350:
1351: Cursor tot_sub_line_billed( p_cle_id IN NUMBER) is
1352: SELECT sum(amount)
1353: FROM oks_bill_sub_lines
1354: WHERE cle_id = p_cle_id;
1355:
1356:
1357: Cursor tot_line_billed( p_cle_id IN NUMBER) is

Line 1952: oks_bill_sub_lines bsl,

1948: Cursor get_future_period_amount is
1949: SELECT nvl(sum(bsl.amount),0) amount
1950: FROM
1951: okc_k_lines_b okl2,
1952: oks_bill_sub_lines bsl,
1953: oks_bill_cont_lines bcl,
1954: okc_k_lines_b okl1
1955: WHERE okl1.id = p_line_id
1956: AND bcl.cle_id = okl1.id

Line 1966: oks_bill_sub_lines bsl

1962: Cursor get_future_prd_amt_covlvl is
1963: SELECT nvl(sum(bsl.amount),0) amount
1964: FROM
1965: okc_k_lines_b okl,
1966: oks_bill_sub_lines bsl
1967: WHERE okl.id = p_line_id
1968: AND bsl.cle_id = okl.id
1969: AND okl.date_terminated is NULL
1970: AND trunc(bsl.date_billed_from) > trunc(p_terminate_date);

Line 1980: oks_bill_sub_lines bsl,

1976: okl.start_date start_date,
1977: okl.end_date end_date,
1978: okl.id id
1979: FROM
1980: oks_bill_sub_lines bsl,
1981: okc_k_lines_b okl
1982: WHERE okl.id = p_line_id
1983: AND okl.id = bsl.cle_id
1984: AND okl.date_terminated is null

Line 1997: oks_bill_sub_lines bsl,

1993: okl1.end_date end_date,
1994: okl1.id id
1995: FROM
1996: okc_k_lines_b okl2,
1997: oks_bill_sub_lines bsl,
1998: oks_bill_cont_lines bcl,
1999: okc_k_lines_b okl1
2000: WHERE okl1.id = p_line_id
2001: AND bcl.cle_id = okl1.id

Line 2332: FROM oks_bill_sub_lines bsl,

2328: ,bsl.Attribute12
2329: ,bsl.Attribute13
2330: ,bsl.Attribute14
2331: ,bsl.Attribute15
2332: FROM oks_bill_sub_lines bsl,
2333: okc_k_lines_b okl
2334: WHERE bcl_id = id_in
2335: AND bsl.cle_id = okl.id
2336: AND okl.date_cancelled is null --LLC BUG FIX 4742661

Line 2414: ,OKS_BILL_SUB_LINES bsl

2410: Cursor cur_billinstance_dtl (p_bcl_id IN NUMBER,
2411: p_cle_id IN NUMBER) is
2412: SELECT bill_instance_number ,bsl_id
2413: FROM OKS_BILL_TXN_LINES txn
2414: ,OKS_BILL_SUB_LINES bsl
2415: WHERE txn.bcl_id = p_bcl_id
2416: AND bsl.cle_id = p_cle_id
2417: AND bsl.id = txn.bsl_id;
2418:

Line 3516: FROM oks_bill_sub_lines bsl

3512: **************************************************************/
3513:
3514: Cursor bsl_cur (p_id in number) is
3515: SELECT bsl.*
3516: FROM oks_bill_sub_lines bsl
3517: WHERE bsl.bcl_id = p_id;
3518:
3519: Cursor bsd_cur (p_id in number) is
3520: Select * from oks_bill_sub_line_dtls

Line 4145: Select bsl.id from oks_bill_sub_lines bsl,

4141: where cle_id = p_id
4142: and bill_action = 'RI';
4143:
4144: Cursor sub_line_billed_cur (p_id IN NUMBER) is
4145: Select bsl.id from oks_bill_sub_lines bsl,
4146: oks_bill_cont_lines bcl
4147: where bsl.cle_id = p_id
4148: and bsl.bcl_id = bcl.id
4149: and bcl.bill_action = 'RI';

Line 4162: from oks_bill_sub_lines

4158: where id = p_bcl_id;
4159:
4160: Cursor bsl_amount (p_bsl_id in number) is
4161: Select nvl(amount,0),cle_id
4162: from oks_bill_sub_lines
4163: where id = p_bsl_id;
4164:
4165: Cursor sub_line_tax(p_sub_line_id in number ) is
4166: Select tax_amount

Line 4173: , oks_bill_sub_lines bsl

4169:
4170: CURSOR l_line_max_bill_date( p_line_id in NUMBER ) is
4171: SELECT max(bsl.date_billed_to) max_bill_date
4172: FROM oks_bill_cont_lines bcl
4173: , oks_bill_sub_lines bsl
4174: WHERE bcl.cle_id = p_line_id
4175: AND bcl.bill_action = 'RI'
4176: AND bcl.id = bsl.bcl_id ;
4177:

Line 4244: oks_bill_sub_lines bsl

4240:
4241: Cursor avg_bcl_amount_partial (p_cle_id in number) is
4242: Select sum(bsl.amount)
4243: from oks_bill_cont_lines bcl,
4244: oks_bill_sub_lines bsl
4245: where bcl.cle_id = p_cle_id
4246: and bsl.bcl_id = bcl.id
4247: and bcl.bill_action <> 'TR'
4248: and trunc(bcl.date_billed_from) >= trunc(p_termination_date);

Line 4253: oks_bill_sub_lines bsl

4249:
4250: Cursor avg_bcl_amount_full (p_cle_id in number) is
4251: Select sum(bsl.amount)
4252: from oks_bill_cont_lines bcl,
4253: oks_bill_sub_lines bsl
4254: where bcl.cle_id = p_cle_id
4255: and bsl.bcl_id = bcl.id
4256: and bcl.bill_action <> 'TR';
4257:

Line 4265: oks_bill_sub_lines bsl

4261: ((trunc(bsl.date_billed_to) - trunc(p_termination_date) + 1) * bsl.amount) /
4262: (trunc(bsl.date_billed_to) - trunc(bsl.date_billed_from) + 1) ,bsl.amount )),0)
4263: -- nvl(sum(bsl.amount),0)
4264: from oks_bill_cont_lines bcl,
4265: oks_bill_sub_lines bsl
4266: where bcl.cle_id = p_cle_id
4267: and bsl.bcl_id = bcl.id
4268: and bcl.bill_action <> 'TR'
4269: and trunc(bsl.date_billed_from) >= trunc(p_termination_date)

Line 4277: oks_bill_sub_lines bsl

4273: Select nvl(sum(decode(sign(trunc(bsl.date_billed_from) - trunc(p_termination_date)) ,-1,
4274: ((trunc(bsl.date_billed_to) - trunc(p_termination_date) + 1) * bsl.amount) /
4275: (trunc(bsl.date_billed_to) - trunc(bsl.date_billed_from) + 1) ,bsl.amount )),0)
4276: from oks_bill_cont_lines bcl,
4277: oks_bill_sub_lines bsl
4278: where bcl.cle_id = p_cle_id
4279: and bsl.bcl_id = bcl.id
4280: and bcl.bill_action <> 'TR'
4281: and trunc(bsl.date_billed_from) >= trunc(p_termination_date)

Line 4294: oks_bill_sub_lines bsl,

4290: Select nvl(sum(decode(sign(trunc(bsl.date_billed_from) - trunc(p_termination_date)) ,-1,
4291: ((trunc(bsl.date_billed_to) - trunc(p_termination_date) + 1) * bsl.amount) /
4292: (trunc(bsl.date_billed_to) - trunc(bsl.date_billed_from) + 1) ,bsl.amount )),0)
4293: from oks_bill_cont_lines bcl,
4294: oks_bill_sub_lines bsl,
4295: okc_k_lines_b line
4296: where bsl.bcl_id = bcl.id
4297: and line.id = bcl.cle_id
4298: and bcl.bill_action <> 'TR'

Line 4310: oks_bill_sub_lines bsl,

4306: Select nvl(sum(decode(sign(trunc(bsl.date_billed_from) - trunc(p_termination_date)) ,-1,
4307: ((trunc(bsl.date_billed_to) - trunc(p_termination_date) + 1) * bsl.amount) /
4308: (trunc(bsl.date_billed_to) - trunc(bsl.date_billed_from) + 1) ,bsl.amount )),0)
4309: from oks_bill_cont_lines bcl,
4310: oks_bill_sub_lines bsl,
4311: okc_k_lines_b line
4312: where bsl.bcl_id = bcl.id
4313: and line.id = bcl.cle_id
4314: and bcl.bill_action <> 'TR'

Line 4601: UPDATE oks_bill_sub_lines

4597: l_bsl_credit_amount := l_bsl_credit_amount +
4598: ((-1)*(l_termination_amount - g_credit_amount)) ;
4599: l_bsl_update_id := g_bsl_id;
4600:
4601: UPDATE oks_bill_sub_lines
4602: SET amount = l_bsl_credit_amount
4603: WHERE id = l_bsl_update_id ;
4604:
4605: l_bcl_credit_amount := l_bcl_credit_amount +

Line 4618: UPDATE oks_bill_sub_lines

4614:
4615: l_bsl_credit_amount := l_bsl_credit_amount + (g_credit_amount - l_termination_amount ) ;
4616: l_bsl_update_id := g_bsl_id;
4617:
4618: UPDATE oks_bill_sub_lines
4619: SET amount = l_bsl_credit_amount
4620: WHERE id = l_bsl_update_id;
4621:
4622: l_bcl_credit_amount := l_bcl_credit_amount + (g_credit_amount - l_termination_amount) ;

Line 4688: UPDATE oks_bill_sub_lines

4684: l_bsl_credit_amount := l_bsl_credit_amount +
4685: ((-1)*(l_termination_amount - g_credit_amount)) ;
4686: l_bsl_update_id := g_bsl_id;
4687:
4688: UPDATE oks_bill_sub_lines
4689: SET amount = l_bsl_credit_amount
4690: WHERE id = l_bsl_update_id ;
4691:
4692: l_bcl_credit_amount := l_bcl_credit_amount +

Line 4706: UPDATE oks_bill_sub_lines

4702: l_bsl_credit_amount := l_bsl_credit_amount +
4703: (g_credit_amount - l_termination_amount ) ;
4704: l_bsl_update_id := g_bsl_id;
4705:
4706: UPDATE oks_bill_sub_lines
4707: SET amount = l_bsl_credit_amount
4708: WHERE id = l_bsl_update_id;
4709:
4710: l_bcl_credit_amount := l_bcl_credit_amount +

Line 4744: UPDATE oks_bill_sub_lines

4740: l_bsl_credit_amount := l_bsl_credit_amount +
4741: ((-1)*(l_termination_amount - g_credit_amount)) ;
4742: l_bsl_update_id := g_bsl_id;
4743:
4744: UPDATE oks_bill_sub_lines
4745: SET amount = l_bsl_credit_amount
4746: WHERE id = l_bsl_update_id ;
4747:
4748: l_bcl_credit_amount := l_bcl_credit_amount +

Line 4761: UPDATE oks_bill_sub_lines

4757:
4758: l_bsl_credit_amount := l_bsl_credit_amount + (g_credit_amount - l_termination_amount ) ;
4759: l_bsl_update_id := g_bsl_id;
4760:
4761: UPDATE oks_bill_sub_lines
4762: SET amount = l_bsl_credit_amount
4763: WHERE id = l_bsl_update_id;
4764:
4765: l_bcl_credit_amount := l_bcl_credit_amount + (g_credit_amount - l_termination_amount) ;

Line 5134: UPDATE oks_bill_sub_lines

5130: l_bsl_credit_amount := l_bsl_credit_amount +
5131: ((-1)*(l_termination_amount - g_credit_amount)) ;
5132: l_bsl_update_id := g_bsl_id;
5133:
5134: UPDATE oks_bill_sub_lines
5135: SET amount = l_bsl_credit_amount
5136: WHERE id = l_bsl_update_id ;
5137:
5138: l_bcl_credit_amount := l_bcl_credit_amount +

Line 5210: UPDATE oks_bill_sub_lines

5206: Elsif g_credit_amount > l_termination_amount then
5207: l_bsl_credit_amount := l_bsl_credit_amount + (g_credit_amount - l_termination_amount ) ;
5208: l_bsl_update_id := g_bsl_id;
5209:
5210: UPDATE oks_bill_sub_lines
5211: SET amount = l_bsl_credit_amount
5212: WHERE id = l_bsl_update_id ;
5213:
5214: l_bcl_credit_amount := l_bcl_credit_amount + (g_credit_amount - l_termination_amount) ;

Line 5620: oks_bill_sub_lines bsl

5616: Cursor l_date_csr Is
5617: SELECT Min(bsl.DATE_BILLED_FROM)
5618: ,Max(bsl.DATE_BILLED_TO)
5619: FROM oks_bill_cont_lines bcl ,
5620: oks_bill_sub_lines bsl
5621: WHERE bsl.cle_id = p_cle_id
5622: AND bsl.bcl_id = bcl.id
5623: AND bcl.bill_action = 'RI';
5624:

Line 5628: oks_bill_sub_lines bsl,

5624:
5625: Cursor l_tot_csr Is
5626: SELECT NVL(Sum(NVL(bsd.Result,0)),0)
5627: FROM oks_bill_cont_lines bcl,
5628: oks_bill_sub_lines bsl,
5629: oks_bill_sub_line_dtls bsd
5630: WHERE bsl.cle_id = p_cle_id
5631: AND bsl.bcl_id = bcl.id
5632: AND bcl.bill_action ='RI'

Line 5745: FROM oks_bill_sub_lines

5741: IS
5742: /* ONE is added to count to consider the unbilled current period */
5743: CURSOR billed_period_csr (p_cle_id IN NUMBER) IS
5744: SELECT count(*) + 1
5745: FROM oks_bill_sub_lines
5746: WHERE cle_id = p_cle_id;
5747:
5748: CURSOR total_billed_qty (p_cle_id IN NUMBER) IS
5749: SELECT sum(result)

Line 5751: oks_bill_sub_lines bsl

5747:
5748: CURSOR total_billed_qty (p_cle_id IN NUMBER) IS
5749: SELECT sum(result)
5750: FROM oks_bill_sub_line_dtls bsd,
5751: oks_bill_sub_lines bsl
5752: WHERE bsl.cle_id = p_cle_id
5753: AND bsd.bsl_id = bsl.id;
5754:
5755: CURSOR l_max_date_end (p_cle_id IN NUMBER, p_date IN DATE) IS

Line 6433: ,oks_bill_sub_lines line

6429:
6430: Cursor l_actual_counter_csr(p_cle_id IN NUMBER) Is
6431: SELECT nvl(end_reading,0) qty
6432: FROM Oks_bill_sub_line_dtls ldtl
6433: ,oks_bill_sub_lines line
6434: WHERE line.cle_id = p_cle_id
6435: AND ldtl.bsl_id = line.id
6436: AND nvl(end_reading,0) > 0
6437: AND trunc(date_billed_from) < trunc(p_start_date)

Line 6454: ,oks_bill_sub_lines line

6450:
6451: Cursor l_actual_csr(p_cle_id IN NUMBER) Is
6452: SELECT NVL(sign(ldtl.amount)*Result,0) + nvl(base_reading,0) qty
6453: FROM Oks_bill_sub_line_dtls ldtl
6454: ,oks_bill_sub_lines line
6455: WHERE line.cle_id = p_cle_id
6456: AND ldtl.bsl_id = line.id
6457: ORDER BY date_billed_to desc ;
6458:

Line 6473: ,oks_bill_sub_lines line

6469:
6470: Cursor l_ccr_id_csr Is
6471: SELECT end_reading read,ccr_id,cgr_id
6472: FROM Oks_bill_sub_line_dtls ldtl
6473: ,oks_bill_sub_lines line
6474: WHERE line.cle_id = p_cle_id
6475: AND ldtl.bsl_id = line.id
6476: -- Bug#4730007 nechatur 1-Dec-2005
6477: -- Order By ldtl.id desc;

Line 6548: ,oks_bill_sub_lines line

6544:
6545: Cursor l_actual_term_csr(p_cle_id IN NUMBER) Is
6546: SELECT NVL(sign(ldtl.amount)*Result,0) + nvl(base_reading,0) qty
6547: FROM Oks_bill_sub_line_dtls ldtl
6548: ,oks_bill_sub_lines line
6549: WHERE line.cle_id = p_cle_id
6550: AND ldtl.bsl_id = line.id
6551: AND trunc(date_billed_from) < trunc(p_start_date)
6552: ORDER BY date_billed_to desc;

Line 7016: UPDATE oks_bill_sub_lines

7012: SET amount = nvl(amount,0) + round_amount,
7013: currency_code = l_cur_holder
7014: WHERE id = p_bcl_id;
7015:
7016: UPDATE oks_bill_sub_lines
7017: SET amount = round_amount,
7018: average = 0
7019: WHERE id = p_bsl_id;
7020:

Line 7828: From oks_bill_sub_lines

7824:
7825: CURSOR l_amount_csr(id_in Number)
7826: IS
7827: Select nvl(sum(NVL(amount,0)),0) amount_billed
7828: From oks_bill_sub_lines
7829: Where cle_id = id_in;
7830:
7831: Cursor l_inv_item_csr(p_cle_id Number)
7832: Is

Line 8024: oks_bill_sub_lines_v

8020:
8021: /* The above cursor is for get the billed amount so far.
8022: To support , middle of the contract amount changes.
8023: select sum(amount) into l_amount_billed
8024: oks_bill_sub_lines_v
8025: cle_id = l_covlvl_rec.id;
8026: */
8027:
8028:

Line 8156: oks_bill_sub_lines bsl

8152: Cursor check_term_cur(p_cle_id NUMBER) is
8153: SELECT bsl.id,
8154: bcl.cle_id top_line_id
8155: FROM oks_bill_cont_lines bcl,
8156: oks_bill_sub_lines bsl
8157: WHERE bsl.bcl_id = bcl.id
8158: AND bcl.bill_action = 'TR'
8159: AND bsl.cle_id = p_cle_id;
8160:

Line 8186: SELECT bsl.id FROM oks_bill_sub_lines bsl,

8182: (line1.sts_code = 'HOLD'));
8183:
8184:
8185: Cursor sub_line_billed_cur (p_id IN NUMBER) is
8186: SELECT bsl.id FROM oks_bill_sub_lines bsl,
8187: oks_bill_cont_lines bcl
8188: WHERE bsl.cle_id = p_id
8189: AND bsl.bcl_id = bcl.id
8190: AND bcl.bill_action = 'RI';

Line 8197: Select amount from oks_bill_sub_lines

8193: Select amount from oks_bill_cont_lines
8194: where id = p_bcl_id;
8195:
8196: Cursor bsl_amount (p_bsl_id in number) is
8197: Select amount from oks_bill_sub_lines
8198: where id = p_bsl_id;
8199:
8200: --04-JAN-2006 mchoudha for bug#4738970
8201: --Added this cursor to fetch the ste_code

Line 8215: oks_bill_sub_lines bsl

8211: ((trunc(bsl.date_billed_to) - trunc(p_termination_date) + 1) * bsl.amount) /
8212: (trunc(bsl.date_billed_to) - trunc(bsl.date_billed_from) + 1) ,bsl.amount )),0)
8213: -- nvl(sum(bsl.amount),0)
8214: from oks_bill_cont_lines bcl,
8215: oks_bill_sub_lines bsl
8216: where bcl.cle_id = p_cle_id
8217: and bsl.bcl_id = bcl.id
8218: and bcl.bill_action <> 'TR'
8219: --and trunc(bsl.date_billed_from) >= trunc(p_termination_date)

Line 8228: oks_bill_sub_lines bsl

8224: Select nvl(sum(decode(sign(trunc(bsl.date_billed_from) - trunc(p_termination_date)) ,-1,
8225: ((trunc(bsl.date_billed_to) - trunc(p_termination_date) + 1) * bsl.amount) /
8226: (trunc(bsl.date_billed_to) - trunc(bsl.date_billed_from) + 1) ,bsl.amount )),0)
8227: from oks_bill_cont_lines bcl,
8228: oks_bill_sub_lines bsl
8229: where bcl.cle_id = p_cle_id
8230: and bsl.bcl_id = bcl.id
8231: and bcl.bill_action <> 'TR'
8232: --and trunc(bsl.date_billed_from) >= trunc(p_termination_date)

Line 8366: UPDATE oks_bill_sub_lines

8362: If g_credit_amount < p_override_amount then
8363: l_bsl_credit_amount := l_bsl_credit_amount + ((-1)*(p_override_amount - g_credit_amount)) ;
8364: l_bsl_id := g_bsl_id;
8365:
8366: UPDATE oks_bill_sub_lines
8367: SET amount = l_bsl_credit_amount
8368: WHERE id = l_bsl_id ;
8369:
8370: l_bcl_credit_amount := l_bcl_credit_amount + ((-1)*(p_override_amount - g_credit_amount)) ;

Line 8382: UPDATE oks_bill_sub_lines

8378:
8379: l_bsl_credit_amount := l_bsl_credit_amount + (g_credit_amount - p_override_amount ) ;
8380: l_bsl_id := g_bsl_id;
8381:
8382: UPDATE oks_bill_sub_lines
8383: SET amount = l_bsl_credit_amount
8384: WHERE id = l_bsl_id ;
8385:
8386: l_bcl_credit_amount := l_bcl_credit_amount + (g_credit_amount - p_override_amount) ;

Line 8599: FROM oks_bill_sub_lines

8595:
8596: CURSOR max_date_billed_to_Cur (p_cle_id IN NUMBER)
8597: IS
8598: SELECT max(date_billed_to)
8599: FROM oks_bill_sub_lines
8600: WHERE cle_id = p_cle_id;
8601:
8602: Cursor l_line_csr(p_id in NUMBER) is
8603: SELECT start_date,end_date,sts_code,

Line 8656: Select amount from oks_bill_sub_lines

8652: Select amount from oks_bill_cont_lines
8653: where id = p_bcl_id;
8654:
8655: Cursor bsl_amount (p_bsl_id in number) is
8656: Select amount from oks_bill_sub_lines
8657: where id = p_bsl_id;
8658:
8659: l_bcl_credit_amount NUMBER;
8660: l_bsl_credit_amount NUMBER;

Line 8980: UPDATE oks_bill_sub_lines

8976: If g_credit_amount < p_override_amount then
8977: l_bsl_credit_amount := l_bsl_credit_amount + ((-1)*(p_override_amount - g_credit_amount)) ;
8978: l_bsl_id := g_bsl_id;
8979:
8980: UPDATE oks_bill_sub_lines
8981: SET amount = l_bsl_credit_amount
8982: WHERE id = l_bsl_id ;
8983:
8984: l_bcl_credit_amount := l_bcl_credit_amount + ((-1)*(p_override_amount - g_credit_amount)) ;

Line 8996: UPDATE oks_bill_sub_lines

8992:
8993: l_bsl_credit_amount := l_bsl_credit_amount + (g_credit_amount - p_override_amount ) ;
8994: l_bsl_id := g_bsl_id;
8995:
8996: UPDATE oks_bill_sub_lines
8997: SET amount = l_bsl_credit_amount
8998: WHERE id = l_bsl_id ;
8999:
9000: l_bcl_credit_amount := l_bcl_credit_amount + (g_credit_amount - p_override_amount) ;

Line 9071: ,OKS_BILL_SUB_LINES BSL

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

Line 9111: ,OKS_BILL_SUB_LINES BSL

9107: CURSOR l_TOP_LINE_BILLED_CSR IS
9108: SELECT nvl(SUM(BSL.amount),0) billed
9109: FROM OKC_K_LINES_B OKCL
9110: ,OKS_BILL_CONT_LINES BCL
9111: ,OKS_BILL_SUB_LINES BSL
9112: WHERE ( OKCL.cle_id = p_id
9113: OR ( OKCL.ID = p_id and OKCL.lse_id = 46))
9114: AND OKCL.lse_id in ( 7,8,9,10,11,13,25,35,46)
9115: AND OKCL.id = BSL.cle_id

Line 9137: ,OKS_BILL_SUB_LINES BSL

9133:
9134: CURSOR l_SUB_LINE_BILLED_CSR IS
9135: SELECT nvl(SUM(BSL.amount),0) billed
9136: FROM OKS_BILL_CONT_LINES BCL
9137: ,OKS_BILL_SUB_LINES BSL
9138: WHERE BSL.cle_id = p_id
9139: AND BSL.bcl_id = BCL.id
9140: AND BCL.bill_action = 'RI';
9141: l_unbilled NUMBER ;

Line 9219: FROM oks_bill_sub_lines bsl,

9215: WHERE cle_id = p_sub_line_id ;
9216:
9217: CURSOR l_credit_csr(p_sub_line_id in NUMBER ) is
9218: SELECT sum(bsl.amount) suppressed_credit
9219: FROM oks_bill_sub_lines bsl,
9220: oks_bill_cont_lines bcl
9221: WHERE bsl.cle_id = p_sub_line_id
9222: AND bcl.id = bsl.bcl_id
9223: AND btn_id is null

Line 9228: FROM oks_bill_sub_lines bsl,

9224: AND bcl.bill_action = 'TR';
9225:
9226: CURSOR l_suppressed_credit_csr(p_sub_line_id in NUMBER ) is
9227: SELECT sum(bsl.amount) suppressed_credit
9228: FROM oks_bill_sub_lines bsl,
9229: oks_bill_cont_lines bcl
9230: WHERE bsl.cle_id = p_sub_line_id
9231: AND bcl.id = bsl.bcl_id
9232: AND btn_id = -44

Line 9995: FROM oks_bill_sub_lines bsl

9991: IS
9992: SELECT sum(bsl.amount) ,
9993: max(bsl.date_billed_From),
9994: max(bsl.date_billed_to)
9995: FROM oks_bill_sub_lines bsl
9996: WHERE bsl.cle_id = p_cle_id;
9997:
9998: --Cursor to get the billing details for the subline
9999: Cursor bsl_cur (p_cle_id IN NUMBER)

Line 10007: oks_bill_sub_lines bsl,

10003: bsl.date_billed_to,
10004: bsl.amount,
10005: bsd.result
10006: FROM oks_bill_cont_lines bcl,
10007: oks_bill_sub_lines bsl,
10008: oks_bill_sub_line_dtls bsd
10009: WHERE bcl.id = bsl.bcl_id
10010: AND bsl.cle_id = p_cle_id
10011: AND bsd.bsl_id = bsl.id

Line 10485: FROM oks_bill_sub_lines bsl

10481: IS
10482: SELECT sum(bsl.amount) ,
10483: max(bsl.date_billed_From),
10484: max(bsl.date_billed_to)
10485: FROM oks_bill_sub_lines bsl
10486: WHERE bsl.cle_id = p_cle_id;
10487:
10488: CURSOR om_period_csr(p_id IN NUMBER) IS
10489: select oel.service_period,oel.service_duration,