APPS.IEX_PROMISES_BATCH_PUB dependencies on AR_ADJUSTMENTS

Line 1947: 'FROM ar_adjustments ara, ' ||

1943: 'ara.adjustment_id, ' ||
1944: '-ara.amount, ' ||
1945: 'ara.apply_date, ' ||
1946: '-ara.amount -nvl(SUM(pax.amount_applied), 0) ' ||
1947: 'FROM ar_adjustments ara, ' ||
1948: 'iex_prd_appl_xref pax ' ||
1949: 'WHERE(TRUNC(ara.apply_date) BETWEEN TRUNC(:promise_cr_date) ' ||
1950: 'AND TRUNC(sysdate)) ' ||
1951: 'AND ara.status = ''A'' ' ||

Line 1965: FROM ar_adjustments

1961: 'ara.apply_date';
1962:
1963: SELECT count(adjustment_id)
1964: into l_adjustment_count
1965: FROM ar_adjustments
1966: WHERE PAYMENT_SCHEDULE_ID = P_PROMISES_TBL(i).PAYMENT_SCHEDULE_ID;
1967:
1968: IF l_adjustment_count = 0 THEN
1969: vSQL := vSQL_pay_only;