APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_BILL_SUB_LINES

Line 6679: FROM oks_bill_sub_lines_v

6675: IS
6676: CURSOR l_bill_csr (p_cle_id NUMBER)
6677: IS
6678: SELECT NVL (SUM (amount), 0)
6679: FROM oks_bill_sub_lines_v
6680: WHERE cle_id = p_cle_id;
6681:
6682: CURSOR l_rule_csr (p_cle_id NUMBER)
6683: IS

Line 6691: FROM oks_bill_sub_lines bsl

6687:
6688: CURSOR l_credit_csr (p_cle_id NUMBER)
6689: IS
6690: SELECT NVL (SUM (amount), 0)
6691: FROM oks_bill_sub_lines bsl
6692: WHERE bsl.cle_id = p_cle_id
6693: AND EXISTS (SELECT 1
6694: FROM oks_bill_cont_lines bcl
6695: WHERE bcl.ID = bsl.bcl_id AND bill_action = 'TR');

Line 6709: FROM oks_bill_sub_lines

6705: IS
6706: SELECT NVL (SUM (trx_line_tax_amount), 0)
6707: FROM oks_bill_txn_lines
6708: WHERE bsl_id IN (SELECT ID
6709: FROM oks_bill_sub_lines
6710: WHERE cle_id = p_cle_id);
6711:
6712: --bug end 3736860
6713: CURSOR l_serv_csr (p_serv_id NUMBER)

Line 7523: FROM oks_bill_sub_lines

7519: --billed upto date
7520: CURSOR l_billend_csr (p_cle_id NUMBER)
7521: IS
7522: SELECT MAX (date_billed_to) date_billed_to
7523: FROM oks_bill_sub_lines
7524: WHERE cle_id = p_cle_id;
7525:
7526: CURSOR l_cov_csr (p_cle_id NUMBER)
7527: IS

Line 7543: FROM oks_bill_sub_lines_v

7539: --total billed amount
7540: CURSOR l_billed_amount_csr (p_cle_id NUMBER)
7541: IS
7542: SELECT NVL (SUM (amount), 0)
7543: FROM oks_bill_sub_lines_v
7544: WHERE cle_id = p_cle_id;
7545:
7546: --credit amount
7547: CURSOR l_credit_csr (p_cle_id NUMBER)

Line 7550: FROM oks_bill_sub_lines bsl

7546: --credit amount
7547: CURSOR l_credit_csr (p_cle_id NUMBER)
7548: IS
7549: SELECT NVL (SUM (amount), 0)
7550: FROM oks_bill_sub_lines bsl
7551: WHERE bsl.cle_id = p_cle_id
7552: AND EXISTS (SELECT 1
7553: FROM oks_bill_cont_lines bcl
7554: WHERE bcl.ID = bsl.bcl_id AND bill_action = 'TR');

Line 7568: FROM oks_bill_sub_lines

7564: IS
7565: SELECT NVL (SUM (trx_line_tax_amount), 0)
7566: FROM oks_bill_txn_lines
7567: WHERE bsl_id IN (SELECT ID
7568: FROM oks_bill_sub_lines
7569: WHERE cle_id = p_cle_id);
7570:
7571: --bug end 3736860
7572: CURSOR l_serv_csr (p_serv_id NUMBER)

Line 15507: FROM oks_bill_sub_lines_v

15503:
15504: CURSOR l_bill_csr (p_cle_id NUMBER)
15505: IS
15506: SELECT SUM (amount)
15507: FROM oks_bill_sub_lines_v
15508: WHERE cle_id = p_cle_id;
15509:
15510: CURSOR l_serv_csr (p_serv_id NUMBER)
15511: IS