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 1747: -- OKL_BILLING_UTIL_PVT.INV_LN_AMT_REMAINING_W_INCTAX

1743: -- Get Unpaid Invoices For the Contract Stream
1744: ------------------------------------------------------------
1745: -- Bug 6802801
1746: -- Bug# 7720775: Changed API call to
1747: -- OKL_BILLING_UTIL_PVT.INV_LN_AMT_REMAINING_W_INCTAX
1748: -- Added parameter p_sty_id
1749: CURSOR unpaid_invs_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_id NUMBER ) IS
1750: SELECT
1751: tai.date_entered date_billed,

Line 1762: OKL_BILLING_UTIL_PVT.INV_LN_AMT_ORIG_WOTAX

1758: khr.currency_code currency_code,
1759: khr.authoring_org_id authoring_org_id,
1760: sty.code comments,
1761: sty.taxable_default_yn taxable_default_yn,
1762: OKL_BILLING_UTIL_PVT.INV_LN_AMT_ORIG_WOTAX
1763: (tldv.CUSTOMER_TRX_ID, tldv.CUSTOMER_TRX_LINE_ID) amount,
1764: khr.sts_code sts_code,
1765: tld.id tld_id,
1766: OKL_BILLING_UTIL_PVT.INV_LN_AMT_REMAINING_W_INCTAX

Line 1766: OKL_BILLING_UTIL_PVT.INV_LN_AMT_REMAINING_W_INCTAX

1762: OKL_BILLING_UTIL_PVT.INV_LN_AMT_ORIG_WOTAX
1763: (tldv.CUSTOMER_TRX_ID, tldv.CUSTOMER_TRX_LINE_ID) amount,
1764: khr.sts_code sts_code,
1765: tld.id tld_id,
1766: OKL_BILLING_UTIL_PVT.INV_LN_AMT_REMAINING_W_INCTAX
1767: (tldv.CUSTOMER_TRX_ID, tldv.CUSTOMER_TRX_LINE_ID) amount_due_remaining,
1768: PS.trx_number trx_number,
1769: PS.class,
1770: PS.TERMS_SEQUENCE_NUMBER