APPS.IEX_PROMISES_BATCH_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 1541: from iex_promise_details prd, iex_delinquencies del, ar_payment_schedules aps --added for Bug 6446848 08-Dec-2008 barathsr

1537: last_updated_by = G_USER_ID
1538: WHERE
1539: promise_detail_id in
1540: (select prd.promise_detail_id
1541: from iex_promise_details prd, iex_delinquencies del, ar_payment_schedules aps --added for Bug 6446848 08-Dec-2008 barathsr
1542: where prd.delinquency_id is not null and
1543: prd.delinquency_id = del.delinquency_id and
1544: prd.org_id = del.org_id and --Added for bug 7237026 barathsr 31-Dec-2008
1545: del.payment_schedule_id=aps.payment_schedule_id and --added for Bug 6446848 08-Dec-2008 barathsr

Line 1996: 'AR_PAYMENT_SCHEDULES psa ' ||

1992: 'NULL ' ||
1993: 'from ' ||
1994: 'AR_RECEIVABLE_APPLICATIONS raa, ' ||
1995: 'IEX_prd_appl_xref pax, ' ||
1996: 'AR_PAYMENT_SCHEDULES psa ' ||
1997: 'where ' ||
1998: '(trunc(raa.apply_date) between trunc(:PROMISE_CR_DATE) and trunc(sysdate)) and ' ||
1999: 'raa.status = ''ACC'' and ' ||
2000: 'raa.amount_applied > 0 and ' ||

Line 2051: ' AR_PAYMENT_SCHEDULES PMTSCH, '||

2047: ' NULL ' ||
2048: ' From ' ||
2049: ' OKL_CNSLD_AR_STRMS_B CNSLD, '||
2050: ' AR_RECEIVABLE_APPLICATIONS ARAPP, '||
2051: ' AR_PAYMENT_SCHEDULES PMTSCH, '||
2052: ' IEX_prd_appl_xref PAX '||
2053: ' Where '||
2054: ' CNSLD.khr_id = :CONTRACT_ID '||
2055: ' and CNSLD.receivables_invoice_id = PMTSCH.customer_trx_id '||