APPS.OKL_BILLING_UTIL_PVT dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 185: FROM ar_receivable_applications_all app,

181: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
182:
183: CURSOR tax_applied_csr(p_header_id NUMBER, p_line_id NUMBER) IS
184: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) tax_applied
185: FROM ar_receivable_applications_all app,
186: ar_payment_schedules_all sch,
187: ar_distributions_all ad,
188: ra_customer_trx_lines_all lines
189: WHERE app.status = 'APP'

Line 221: FROM ar_receivable_applications_all app,

217: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
218:
219: CURSOR tax_credited_csr(p_header_id NUMBER, p_line_id NUMBER) IS
220: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) credit_applied
221: FROM ar_receivable_applications_all app,
222: ar_payment_schedules_all sch,
223: ar_distributions_all ad,
224: ra_customer_trx_lines_all lines
225: WHERE app.status = 'APP'

Line 304: FROM ar_receivable_applications_all app,

300: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
301: --dkagrawa modified the cusrsor to add class CM
302: CURSOR invoice_amount_applied_csr(p_header_id NUMBER) IS
303: SELECT NVL(SUM(app.amount_applied),0) AMOUNT_APPLIED
304: FROM ar_receivable_applications_all app,
305: ar_payment_schedules_all sch
306: WHERE app.status = 'APP'
307: AND app.applied_payment_schedule_id = sch.payment_schedule_id
308: AND sch.class IN ('INV','CM') --Receipt can be applied against credit memo

Line 324: FROM ar_receivable_applications_all app,

320: FUNCTION INVOICE_AMOUNT_CREDITED(
321: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
322: CURSOR invoice_amount_credited_csr(p_header_id NUMBER) IS
323: SELECT NVL(SUM(app.amount_applied),0) AMOUNT_CREDITED
324: FROM ar_receivable_applications_all app,
325: ar_payment_schedules_all sch
326: WHERE app.status = 'APP'
327: AND app.applied_payment_schedule_id = sch.payment_schedule_id
328: AND sch.class = 'INV'

Line 1208: FROM ar_receivable_applications_all app,

1204: p_customer_trx_id IN NUMBER,
1205: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
1206: CURSOR line_credited_csr(p_header_id NUMBER, p_line_id NUMBER) IS
1207: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) credit_applied
1208: FROM ar_receivable_applications_all app,
1209: ar_payment_schedules_all sch,
1210: ar_distributions_all ad
1211: WHERE app.status = 'APP'
1212: AND app.applied_payment_schedule_id = sch.payment_schedule_id

Line 1235: FROM ar_receivable_applications_all app,

1231: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
1232: --dkagrawa modified the cusrsor to add class CM
1233: CURSOR line_applied_csr(p_header_id NUMBER, p_line_id NUMBER) IS
1234: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) line_applied
1235: FROM ar_receivable_applications_all app,
1236: ar_payment_schedules_all sch,
1237: ar_distributions_all ad
1238: WHERE app.status = 'APP'
1239: AND app.applied_payment_schedule_id = sch.payment_schedule_id

Line 1375: FROM ar_receivable_applications_all app,

1371: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
1372:
1373: CURSOR tax_applied_csr(p_header_id NUMBER, p_line_id NUMBER) IS
1374: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) tax_applied
1375: FROM ar_receivable_applications_all app,
1376: ar_payment_schedules_all sch,
1377: ar_distributions_all ad,
1378: ra_customer_trx_lines_all lines
1379: WHERE app.status = 'APP'

Line 1411: FROM ar_receivable_applications_all app,

1407: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
1408:
1409: CURSOR tax_credited_csr(p_header_id NUMBER, p_line_id NUMBER) IS
1410: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) credit_applied
1411: FROM ar_receivable_applications_all app,
1412: ar_payment_schedules_all sch,
1413: ar_distributions_all ad,
1414: ra_customer_trx_lines_all lines
1415: WHERE app.status = 'APP'