DBA Data[Home] [Help]

APPS.OKL_REBOOK_CM_PVT dependencies on OKL_BILLING_UTIL_PVT

Line 181: -- OKL_BILLING_UTIL_PVT.INV_LN_AMT_REMAINING_W_INCTAX

177: --Bug 5000886: Removed references of stream tables in the following cursor
178:
179: -- Bug 6802801
180: -- Bug# 7720775: Changed API call to
181: -- OKL_BILLING_UTIL_PVT.INV_LN_AMT_REMAINING_W_INCTAX
182: CURSOR unpaid_invs_csr ( p_khr_id NUMBER, p_kle_id NUMBER ) IS
183: SELECT
184: tai.date_entered date_billed,
185: khr.id khr_id,

Line 195: OKL_BILLING_UTIL_PVT.INV_LN_AMT_ORIG_WOTAX

191: khr.currency_code currency_code,
192: khr.authoring_org_id authoring_org_id,
193: sty.code comments,
194: sty.taxable_default_yn taxable_default_yn,
195: OKL_BILLING_UTIL_PVT.INV_LN_AMT_ORIG_WOTAX
196: (tldv.CUSTOMER_TRX_ID, tldv.CUSTOMER_TRX_LINE_ID) amount,
197: khr.sts_code sts_code,
198: tld.id tld_id,
199: OKL_BILLING_UTIL_PVT.INV_LN_AMT_REMAINING_W_INCTAX

Line 199: OKL_BILLING_UTIL_PVT.INV_LN_AMT_REMAINING_W_INCTAX

195: OKL_BILLING_UTIL_PVT.INV_LN_AMT_ORIG_WOTAX
196: (tldv.CUSTOMER_TRX_ID, tldv.CUSTOMER_TRX_LINE_ID) amount,
197: khr.sts_code sts_code,
198: tld.id tld_id,
199: OKL_BILLING_UTIL_PVT.INV_LN_AMT_REMAINING_W_INCTAX
200: (tldv.CUSTOMER_TRX_ID, tldv.CUSTOMER_TRX_LINE_ID) amount_due_remaining,
201: PS.trx_number trx_number,
202: PS.class,
203: PS.TERMS_SEQUENCE_NUMBER

Line 1732: -- OKL_BILLING_UTIL_PVT.INV_LN_AMT_REMAINING_W_INCTAX

1728: -- Get Unpaid Invoices For the Contract Stream
1729: ------------------------------------------------------------
1730: -- Bug 6802801
1731: -- Bug# 7720775: Changed API call to
1732: -- OKL_BILLING_UTIL_PVT.INV_LN_AMT_REMAINING_W_INCTAX
1733: -- Added parameter p_sty_id
1734: CURSOR unpaid_invs_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_id NUMBER ) IS
1735: SELECT
1736: tai.date_entered date_billed,

Line 1747: OKL_BILLING_UTIL_PVT.INV_LN_AMT_ORIG_WOTAX

1743: khr.currency_code currency_code,
1744: khr.authoring_org_id authoring_org_id,
1745: sty.code comments,
1746: sty.taxable_default_yn taxable_default_yn,
1747: OKL_BILLING_UTIL_PVT.INV_LN_AMT_ORIG_WOTAX
1748: (tldv.CUSTOMER_TRX_ID, tldv.CUSTOMER_TRX_LINE_ID) amount,
1749: khr.sts_code sts_code,
1750: tld.id tld_id,
1751: OKL_BILLING_UTIL_PVT.INV_LN_AMT_REMAINING_W_INCTAX

Line 1751: OKL_BILLING_UTIL_PVT.INV_LN_AMT_REMAINING_W_INCTAX

1747: OKL_BILLING_UTIL_PVT.INV_LN_AMT_ORIG_WOTAX
1748: (tldv.CUSTOMER_TRX_ID, tldv.CUSTOMER_TRX_LINE_ID) amount,
1749: khr.sts_code sts_code,
1750: tld.id tld_id,
1751: OKL_BILLING_UTIL_PVT.INV_LN_AMT_REMAINING_W_INCTAX
1752: (tldv.CUSTOMER_TRX_ID, tldv.CUSTOMER_TRX_LINE_ID) amount_due_remaining,
1753: PS.trx_number trx_number,
1754: PS.class,
1755: PS.TERMS_SEQUENCE_NUMBER