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 251: FROM ar_receivable_applications_all app,

247: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
248:
249: CURSOR tax_credited_csr(p_header_id NUMBER, p_line_id NUMBER) IS
250: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) credit_applied
251: FROM ar_receivable_applications_all app,
252: ar_payment_schedules_all sch,
253: ar_distributions_all ad,
254: ra_customer_trx_lines_all lines
255: WHERE app.status = 'APP'

Line 322: FROM ar_receivable_applications_all app,

318: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
319:
320: CURSOR c_line_applied_csr(p_header_id NUMBER, p_line_id NUMBER) IS
321: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) line_applied
322: FROM ar_receivable_applications_all app,
323: ar_payment_schedules_all sch,
324: ar_distributions_all ad
325: WHERE app.status = 'APP'
326: AND app.payment_schedule_id = sch.payment_schedule_id

Line 336: FROM ar_receivable_applications_all app,

332: AND ad.ref_Customer_trx_Line_Id = p_line_id;
333:
334: CURSOR c_tax_applied_csr(p_header_id NUMBER, p_line_id NUMBER) IS
335: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) tax_applied
336: FROM ar_receivable_applications_all app,
337: ar_payment_schedules_all sch,
338: ar_distributions_all ad,
339: ra_customer_trx_lines_all lines
340: WHERE app.status = 'APP'

Line 457: FROM ar_receivable_applications_all app,

453: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
454: --dkagrawa modified the cusrsor to add class CM
455: CURSOR invoice_amount_applied_csr(p_header_id NUMBER) IS
456: SELECT NVL(SUM(app.amount_applied),0) AMOUNT_APPLIED
457: FROM ar_receivable_applications_all app,
458: ar_payment_schedules_all sch
459: WHERE app.status = 'APP'
460: AND app.applied_payment_schedule_id = sch.payment_schedule_id
461: AND sch.class IN ('INV','CM') --Receipt can be applied against credit memo

Line 477: FROM ar_receivable_applications_all app,

473: FUNCTION INVOICE_AMOUNT_CREDITED(
474: p_customer_trx_id IN NUMBER) RETURN NUMBER IS
475: CURSOR invoice_amount_credited_csr(p_header_id NUMBER) IS
476: SELECT NVL(SUM(app.amount_applied),0) AMOUNT_CREDITED
477: FROM ar_receivable_applications_all app,
478: ar_payment_schedules_all sch
479: WHERE app.status = 'APP'
480: AND app.applied_payment_schedule_id = sch.payment_schedule_id
481: AND sch.class = 'INV'

Line 1361: FROM ar_receivable_applications_all app,

1357: p_customer_trx_id IN NUMBER,
1358: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
1359: CURSOR line_credited_csr(p_header_id NUMBER, p_line_id NUMBER) IS
1360: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) credit_applied
1361: FROM ar_receivable_applications_all app,
1362: ar_payment_schedules_all sch,
1363: ar_distributions_all ad
1364: WHERE app.status = 'APP'
1365: AND app.applied_payment_schedule_id = sch.payment_schedule_id

Line 1388: FROM ar_receivable_applications_all app,

1384: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
1385: --dkagrawa modified the cusrsor to add class CM
1386: CURSOR line_applied_csr(p_header_id NUMBER, p_line_id NUMBER) IS
1387: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) line_applied
1388: FROM ar_receivable_applications_all app,
1389: ar_payment_schedules_all sch,
1390: ar_distributions_all ad
1391: WHERE app.status = 'APP'
1392: AND app.applied_payment_schedule_id = sch.payment_schedule_id

Line 1560: FROM ar_receivable_applications_all app,

1556: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
1557:
1558: CURSOR tax_applied_csr(p_header_id NUMBER, p_line_id NUMBER) IS
1559: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) tax_applied
1560: FROM ar_receivable_applications_all app,
1561: ar_payment_schedules_all sch,
1562: ar_distributions_all ad,
1563: ra_customer_trx_lines_all lines
1564: WHERE app.status = 'APP'

Line 1596: FROM ar_receivable_applications_all app,

1592: p_customer_trx_line_id NUMBER) RETURN NUMBER IS
1593:
1594: CURSOR tax_credited_csr(p_header_id NUMBER, p_line_id NUMBER) IS
1595: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) credit_applied
1596: FROM ar_receivable_applications_all app,
1597: ar_payment_schedules_all sch,
1598: ar_distributions_all ad,
1599: ra_customer_trx_lines_all lines
1600: WHERE app.status = 'APP'