APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_BILL_SUB_LINES

Line 6847: FROM oks_bill_sub_lines_v

6843: IS
6844: CURSOR l_bill_csr (p_cle_id NUMBER)
6845: IS
6846: SELECT NVL (SUM (amount), 0)
6847: FROM oks_bill_sub_lines_v
6848: WHERE cle_id = p_cle_id;
6849:
6850: CURSOR l_rule_csr (p_cle_id NUMBER)
6851: IS

Line 6859: FROM oks_bill_sub_lines bsl

6855:
6856: CURSOR l_credit_csr (p_cle_id NUMBER)
6857: IS
6858: SELECT NVL (SUM (amount), 0)
6859: FROM oks_bill_sub_lines bsl
6860: WHERE bsl.cle_id = p_cle_id
6861: AND EXISTS (SELECT 1
6862: FROM oks_bill_cont_lines bcl
6863: WHERE bcl.ID = bsl.bcl_id AND bill_action = 'TR');

Line 6877: FROM oks_bill_sub_lines

6873: IS
6874: SELECT NVL (SUM (trx_line_tax_amount), 0)
6875: FROM oks_bill_txn_lines
6876: WHERE bsl_id IN (SELECT ID
6877: FROM oks_bill_sub_lines
6878: WHERE cle_id = p_cle_id);
6879:
6880: --bug end 3736860
6881: /* Added for Bug#14325727 */

Line 7704: FROM oks_bill_sub_lines

7700: --billed upto date
7701: CURSOR l_billend_csr (p_cle_id NUMBER)
7702: IS
7703: SELECT MAX (date_billed_to) date_billed_to
7704: FROM oks_bill_sub_lines
7705: WHERE cle_id = p_cle_id;
7706:
7707: CURSOR l_cov_csr (p_cle_id NUMBER)
7708: IS

Line 7724: FROM oks_bill_sub_lines_v

7720: --total billed amount
7721: CURSOR l_billed_amount_csr (p_cle_id NUMBER)
7722: IS
7723: SELECT NVL (SUM (amount), 0)
7724: FROM oks_bill_sub_lines_v
7725: WHERE cle_id = p_cle_id;
7726:
7727: --credit amount
7728: CURSOR l_credit_csr (p_cle_id NUMBER)

Line 7731: FROM oks_bill_sub_lines bsl

7727: --credit amount
7728: CURSOR l_credit_csr (p_cle_id NUMBER)
7729: IS
7730: SELECT NVL (SUM (amount), 0)
7731: FROM oks_bill_sub_lines bsl
7732: WHERE bsl.cle_id = p_cle_id
7733: AND EXISTS (SELECT 1
7734: FROM oks_bill_cont_lines bcl
7735: WHERE bcl.ID = bsl.bcl_id AND bill_action = 'TR');

Line 7749: FROM oks_bill_sub_lines

7745: IS
7746: SELECT NVL (SUM (trx_line_tax_amount), 0)
7747: FROM oks_bill_txn_lines
7748: WHERE bsl_id IN (SELECT ID
7749: FROM oks_bill_sub_lines
7750: WHERE cle_id = p_cle_id);
7751:
7752: --bug end 3736860
7753: /* Added for Bug#14325727 */

Line 15792: FROM oks_bill_sub_lines_v

15788:
15789: CURSOR l_bill_csr (p_cle_id NUMBER)
15790: IS
15791: SELECT SUM (amount)
15792: FROM oks_bill_sub_lines_v
15793: WHERE cle_id = p_cle_id;
15794:
15795: /* Added for Bug#14325727 */
15796: CURSOR l_serv_csr (p_serv_id NUMBER)