APPS.OKL_BILLING_UTIL_PVT dependencies on AR_ADJUSTMENTS_ALL

Line 1280: FROM ar_adjustments_all adj,

1276: p_customer_trx_line_id IN NUMBER) RETURN NUMBER IS
1277:
1278: CURSOR invoice_ln_tax_adj(p_header_id NUMBER, p_line_id NUMBER) IS
1279: SELECT SUM(nvl(dist.amount_cr,0))- SUM(nvl(dist.amount_dr,0)) tax_adjusted
1280: FROM ar_adjustments_all adj,
1281: ar_payment_schedules_all sch,
1282: ar_distributions_all dist,
1283: ra_customer_trx_lines_all lines
1284: WHERE adj.payment_schedule_id = sch.payment_schedule_id

Line 1319: ar_adjustments_all adj ,

1315:
1316: CURSOR invoice_ln_amount_adj(p_header_id NUMBER, p_line_id NUMBER) IS
1317: SELECT SUM(nvl(dist.amount_cr,0))- SUM(nvl(dist.amount_dr,0)) amt_adjsuted
1318: FROM ar_distributions_all dist ,
1319: ar_adjustments_all adj ,
1320: ar_payment_schedules_all aps
1321: WHERE dist.source_table = 'ADJ'
1322: AND dist.source_id = adj.adjustment_id
1323: AND aps.customer_trx_id = p_header_id

Line 1448: FROM ar_adjustments_all adj,

1444: p_customer_trx_line_id IN NUMBER) RETURN NUMBER IS
1445:
1446: CURSOR invoice_ln_tax_adj(p_header_id NUMBER, p_line_id NUMBER) IS
1447: SELECT SUM(nvl(dist.amount_cr,0))- SUM(nvl(dist.amount_dr,0)) tax_adjusted
1448: FROM ar_adjustments_all adj,
1449: ar_payment_schedules_all sch,
1450: ar_distributions_all dist,
1451: ra_customer_trx_lines_all lines
1452: WHERE adj.payment_schedule_id = sch.payment_schedule_id