[Home] [Help]
697: AND pd.status = 'COLLECTABLE'
698: AND pd.state = 'PROMISE'
699: AND d.staged_dunning_level = 0
700: group by pd.delinquency_id
701: having sum(pd.promise_amount) < (select amount_due_remaining from ar_payment_schedules pay,
702: iex_delinquencies del
703: where pay.payment_schedule_id = del.payment_schedule_id
704: and del.delinquency_id = pd.delinquency_id);
705:
712: AND pd.status = 'COLLECTABLE'
713: AND pd.state = 'PROMISE'
714: AND d.staged_dunning_level <> 0
715: group by pd.delinquency_id
716: having sum(pd.promise_amount) >= (select amount_due_remaining from ar_payment_schedules pay,
717: iex_delinquencies del
718: where pay.payment_schedule_id = del.payment_schedule_id
719: and del.delinquency_id = pd.delinquency_id);
720: */
1677: last_updated_by = G_USER_ID
1678: WHERE
1679: promise_detail_id in
1680: (select prd.promise_detail_id
1681: from iex_promise_details prd, iex_delinquencies del, ar_payment_schedules aps --added for Bug 6446848 08-Dec-2008 barathsr
1682: where prd.delinquency_id is not null and
1683: prd.delinquency_id = del.delinquency_id and
1684: prd.org_id = del.org_id and --Added for bug 7237026 barathsr 31-Dec-2008
1685: del.payment_schedule_id=aps.payment_schedule_id and --added for Bug 6446848 08-Dec-2008 barathsr
2132: 'NULL ' ||
2133: 'from ' ||
2134: 'AR_RECEIVABLE_APPLICATIONS raa, ' ||
2135: 'IEX_prd_appl_xref pax, ' ||
2136: 'AR_PAYMENT_SCHEDULES psa ' ||
2137: 'where ' ||
2138: '(trunc(raa.apply_date) between trunc(:PROMISE_CR_DATE) and trunc(sysdate)) and ' ||
2139: 'raa.status = ''ACC'' and ' ||
2140: 'raa.amount_applied > 0 and ' ||
2187: ' NULL ' ||
2188: ' From ' ||
2189: ' OKL_CNSLD_AR_STRMS_B CNSLD, '||
2190: ' AR_RECEIVABLE_APPLICATIONS ARAPP, '||
2191: ' AR_PAYMENT_SCHEDULES PMTSCH, '||
2192: ' IEX_prd_appl_xref PAX '||
2193: ' Where '||
2194: ' CNSLD.khr_id = :CONTRACT_ID '||
2195: ' and CNSLD.receivables_invoice_id = PMTSCH.customer_trx_id '||