APPS.OKL_BILLING_UTIL_PVT dependencies on AR_ADJUSTMENTS_ALL

Line 1435: FROM ar_adjustments_all adj,

1431: p_customer_trx_line_id IN NUMBER) RETURN NUMBER IS
1432:
1433: CURSOR invoice_ln_tax_adj(p_header_id NUMBER, p_line_id NUMBER) IS
1434: SELECT SUM(nvl(dist.amount_cr,0))- SUM(nvl(dist.amount_dr,0)) tax_adjusted
1435: FROM ar_adjustments_all adj,
1436: ar_payment_schedules_all sch,
1437: ar_distributions_all dist,
1438: ra_customer_trx_lines_all lines
1439: WHERE adj.payment_schedule_id = sch.payment_schedule_id

Line 1504: ar_adjustments_all adj ,

1500:
1501: CURSOR invoice_ln_amount_adj(p_header_id NUMBER, p_line_id NUMBER) IS
1502: SELECT SUM(nvl(dist.amount_cr,0))- SUM(nvl(dist.amount_dr,0)) amt_adjsuted
1503: FROM ar_distributions_all dist ,
1504: ar_adjustments_all adj ,
1505: ar_payment_schedules_all aps
1506: WHERE dist.source_table = 'ADJ'
1507: AND dist.source_id = adj.adjustment_id
1508: AND aps.customer_trx_id = p_header_id

Line 1633: FROM ar_adjustments_all adj,

1629: p_customer_trx_line_id IN NUMBER) RETURN NUMBER IS
1630:
1631: CURSOR invoice_ln_tax_adj(p_header_id NUMBER, p_line_id NUMBER) IS
1632: SELECT SUM(nvl(dist.amount_cr,0))- SUM(nvl(dist.amount_dr,0)) tax_adjusted
1633: FROM ar_adjustments_all adj,
1634: ar_payment_schedules_all sch,
1635: ar_distributions_all dist,
1636: ra_customer_trx_lines_all lines
1637: WHERE adj.payment_schedule_id = sch.payment_schedule_id