eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_CUST_OVERVIEW_PVT dependencies on IEX_DELINQUENCIES

Line 60: -- iex_delinquencies del

56: -- SELECT COUNT(DECODE(ps.class, 'INV', ps.payment_schedule_id, 'DM', ps.payment_schedule_id, 'CB', ps.payment_schedule_id, NULL)) cnt_inv,
57: -- COUNT(DECODE(ps.class, 'INV', DECODE(del.status, 'DELINQUENT', del.delinquency_id, 'PREDELINQUENT', del.delinquency_id, NULL), NULL)) cnt_del
58: -- FROM ar_payment_schedules ps,
59: -- hz_cust_accounts ca,
60: -- iex_delinquencies del
61: -- WHERE ca.party_id = p_party_id
62: -- AND ps.customer_id = ca.cust_account_id
63: -- AND ps.status = 'OP'
64: -- AND del.payment_schedule_id(+) = ps.payment_schedule_id;

Line 79: iex_delinquencies del

75: CURSOR c_delinquent_inv IS
76: SELECT COUNT(del.delinquency_id) cnt_del
77: FROM ar_payment_schedules ps,
78: hz_cust_accounts ca,
79: iex_delinquencies del
80: WHERE ca.party_id = p_party_id
81: AND ps.customer_id = ca.cust_account_id
82: AND ps.status = 'OP'
83: AND ps.class = 'INV'

Line 91: FROM iex_delinquencies del

87:
88: -- Delinquencies in Past Year
89: CURSOR c_delinquencies IS
90: SELECT Count(1)
91: FROM iex_delinquencies del
92: WHERE del.party_cust_id = p_party_id
93: AND del.creation_date between sysdate - 365 and sysdate ;
94:
95: -- added by jypark for status in header

Line 229: ' FROM iex_delinquencies' ||

225: ' AND close_date IS NULL ' ||
226: ' AND NVL(DISPOSITION_CODE, '' '') NOT IN (''DISMISSED'',''WITHDRAWN'' )';
227: ELSIF l_delinquency_status = 'DELINQUENT' THEN
228: l_sql_stmt := 'SELECT count(1)' ||
229: ' FROM iex_delinquencies' ||
230: ' WHERE party_cust_id = :party_id' ||
231: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
232: ' AND status = ''DELINQUENT''';
233: --Start bug 9861733 gnramasa 19th July 2010

Line 238: ' FROM iex_litigations ltg, iex_delinquencies del' ||

234: /*
235: ELSIF l_delinquency_status = 'LITIGATION' THEN
236: l_sql_stmt_lsd := ' select count(1) from (' ||
237: ' SELECT litigation_id' ||
238: ' FROM iex_litigations ltg, iex_delinquencies del' ||
239: ' WHERE del.party_cust_id = :party_id' ||
240: ' AND ltg.delinquency_id = del.delinquency_id' ||
241: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
242: ' AND ltg.disposition_code IS NULL ' ||

Line 253: ' FROM iex_repossessions rps, iex_delinquencies del' ||

249: ' AND disposition_code IS NULL )';
250: ELSIF l_delinquency_status = 'REPOSSESSION' THEN
251: l_sql_stmt_lsd := ' select count(1) from (' ||
252: ' SELECT repossession_id' ||
253: ' FROM iex_repossessions rps, iex_delinquencies del' ||
254: ' WHERE del.party_cust_id = :party_id' ||
255: ' AND rps.delinquency_id = del.delinquency_id' ||
256: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
257: ' AND (rps.disposition_code IS NULL or rps.disposition_code = ''A'' or rps.disposition_code = ''W'') ' ||

Line 269: ' FROM iex_writeoffs wrf, iex_delinquencies del' ||

265: --' AND disposition_code IS NULL )';
266: ELSIF l_delinquency_status = 'WRITEOFF' THEN
267: l_sql_stmt_lsd := ' select count(1) from (' ||
268: ' SELECT writeoff_id' ||
269: ' FROM iex_writeoffs wrf, iex_delinquencies del' ||
270: ' WHERE del.party_cust_id = :party_id' ||
271: ' AND wrf.delinquency_id = del.delinquency_id' ||
272: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
273: ' AND (wrf.disposition_code IS NULL or wrf.disposition_code = ''A'' or wrf.disposition_code = ''W'') ' ||

Line 304: ' FROM iex_delinquencies' ||

300: --' AND disposition_code IS NULL )';
301:
302: ELSIF l_delinquency_status = 'PREDELINQUENT' THEN
303: l_sql_stmt := 'SELECT count(1)' ||
304: ' FROM iex_delinquencies' ||
305: ' WHERE party_cust_id = :party_id' ||
306: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
307: ' AND status = ''PREDELINQUENT''';
308: END IF;

Line 356: ' FROM iex_delinquencies' ||

352: ' AND close_date IS NULL ' ||
353: ' AND NVL(DISPOSITION_CODE , '' '') NOT IN (''DISMISSED'',''WITHDRAWN'' )';
354: ELSIF l_delinquency_status = 'DELINQUENT' THEN
355: l_sql_stmt := 'SELECT count(1)' ||
356: ' FROM iex_delinquencies' ||
357: ' WHERE party_cust_id = :party_id' ||
358: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
359: ' AND status = ''DELINQUENT''';
360: /*

Line 364: ' FROM iex_litigations ltg, iex_delinquencies del' ||

360: /*
361: ELSIF l_delinquency_status = 'LITIGATION' THEN
362: l_sql_stmt_lsd := 'select count(1) from (' ||
363: ' SELECT litigation_id' ||
364: ' FROM iex_litigations ltg, iex_delinquencies del' ||
365: ' WHERE del.party_cust_id = :party_id' ||
366: ' AND ltg.delinquency_id = del.delinquency_id' ||
367: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
368: ' AND ltg.disposition_code IS NULL ' ||

Line 379: ' FROM iex_repossessions rps, iex_delinquencies del' ||

375: ' AND disposition_code IS NULL )';
376: ELSIF l_delinquency_status = 'REPOSSESSION' THEN
377: l_sql_stmt_lsd := ' select count(1) from (' ||
378: ' SELECT repossession_id' ||
379: ' FROM iex_repossessions rps, iex_delinquencies del' ||
380: ' WHERE del.party_cust_id = :party_id' ||
381: ' AND rps.delinquency_id = del.delinquency_id' ||
382: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
383: ' AND (rps.disposition_code IS NULL or rps.disposition_code = ''A'' or rps.disposition_code = ''W'') ' ||

Line 396: ' FROM iex_writeoffs wrf, iex_delinquencies del' ||

392: --' AND disposition_code IS NULL )';
393: ELSIF l_delinquency_status = 'WRITEOFF' THEN
394: l_sql_stmt_lsd := ' select count(1) from (' ||
395: ' SELECT writeoff_id' ||
396: ' FROM iex_writeoffs wrf, iex_delinquencies del' ||
397: ' WHERE del.party_cust_id = :party_id' ||
398: ' AND wrf.delinquency_id = del.delinquency_id' ||
399: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
400: ' AND (wrf.disposition_code IS NULL or wrf.disposition_code = ''A'' or wrf.disposition_code = ''W'') ' ||

Line 431: ' FROM iex_delinquencies' ||

427: --' AND disposition_code IS NULL )';
428:
429: ELSIF l_delinquency_status = 'PREDELINQUENT' THEN
430: l_sql_stmt := 'SELECT count(1)' ||
431: ' FROM iex_delinquencies' ||
432: ' WHERE party_cust_id = :party_id' ||
433: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
434: ' AND status = ''PREDELINQUENT''';
435: END IF;

Line 499: -- FROM iex_delinquencies del

495: -- Begin fix bug #4930425-jypark-01/10/2006-removed obsolete query
496: -- -- Delinquent Cases
497: -- CURSOR c_del_cases IS
498: -- SELECT Count(1)
499: -- FROM iex_delinquencies del
500: -- WHERE del.party_cust_id = p_party_id
501: -- and del.case_id is not null
502: -- and del.status = 'DELINQUENT';
503: --

Line 515: -- FROM iex_delinquencies del

511: --
512: -- -- Delinquent Cases in Past Year
513: -- CURSOR c_del_cases_past_year IS
514: -- SELECT Count(1)
515: -- FROM iex_delinquencies del
516: -- WHERE del.party_cust_id = p_party_id
517: -- AND del.creation_date between sysdate - 365 and sysdate
518: -- and del.case_id is not null
519: -- and del.status = 'DELINQUENT';

Line 581: FROM iex_delinquencies

577: l_last_okl_pmt_info_rec Last_OKL_Pmt_Info_Rec_Type;
578:
579: CURSOR c_del(x_delinquency_id NUMBER) IS
580: SELECT payment_schedule_id
581: FROM iex_delinquencies
582: WHERE delinquency_id = x_delinquency_id
583: AND status not in ('CURRENT', 'CLOSE');
584:
585: l_cnt_cur_codes number; --added for MOAC

Line 647: -- iex_delinquencies del,

643: ), 0) dso */
644: FROM ar_payment_schedules ps,
645: hz_cust_accounts ca,
646: -- Begin fix bug #5261855-jypark-06/16/2006-change to based table for performance
647: -- iex_delinquencies del,
648: iex_delinquencies_all del,
649: -- End fix bug #5261855-jypark-06/16/2006-change to based table for performance
650: ar_system_parameters sp
651: WHERE ca.party_id = l_party_id

Line 648: iex_delinquencies_all del,

644: FROM ar_payment_schedules ps,
645: hz_cust_accounts ca,
646: -- Begin fix bug #5261855-jypark-06/16/2006-change to based table for performance
647: -- iex_delinquencies del,
648: iex_delinquencies_all del,
649: -- End fix bug #5261855-jypark-06/16/2006-change to based table for performance
650: ar_system_parameters sp
651: WHERE ca.party_id = l_party_id
652: AND ps.customer_id = ca.cust_account_id

Line 675: iex_delinquencies_all del,

671: SUM(DECODE(del.status, 'DELINQUENT', NVL(acctd_amount_due_remaining,0),
672: 'PREDELINQUENT', NVL(acctd_amount_due_remaining,0),0)) overdue_amt
673: FROM ar_payment_schedules ps,
674: hz_cust_accounts ca,
675: iex_delinquencies_all del,
676: ar_system_parameters sp
677: WHERE ca.party_id = l_party_id
678: AND ps.customer_id = ca.cust_account_id
679: AND ps.status = 'OP'

Line 704: and not exists (select 1 from iex_delinquencies_all where status in ('CURRENT','CLOSE') -- bug 14499531

700: where ca.party_id = l_party_id
701: and ps.customer_id = ca.cust_account_id
702: and ps.status = 'OP')
703: and cm.status='PENDING_APPROVAL'
704: and not exists (select 1 from iex_delinquencies_all where status in ('CURRENT','CLOSE') -- bug 14499531
705: and transaction_id = cm.customer_trx_id);
706:
707: x_object_info_rec.amount_overdue := x_object_info_rec.amount_overdue - l_amount_in_dispute;
708: end if;

Line 735: FROM ar_payment_schedules ps, iex_delinquencies del

731: else
732: --end moac change
733: OPEN c_overdue FOR
734: SELECT sum(acctd_amount_due_remaining) amount
735: FROM ar_payment_schedules ps, iex_delinquencies del
736: WHERE ps.customer_id = p_object_id
737: -- fix bug #3561828 AND ps.due_date < sysdate
738: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due
739: -- AND TRUNC(ps.due_date) < TRUNC(sysdate)

Line 762: and not exists (select 1 from iex_delinquencies_all where status in ('CURRENT','CLOSE') -- bug 14499531

758: where ps.customer_id = p_object_id
759: and ps.org_id = parm.org_id
760: and ps.status = 'OP')
761: and cm.status='PENDING_APPROVAL'
762: and not exists (select 1 from iex_delinquencies_all where status in ('CURRENT','CLOSE') -- bug 14499531
763: and transaction_id = cm.customer_trx_id);
764:
765: x_object_info_rec.amount_overdue := x_object_info_rec.amount_overdue - l_amount_in_dispute;
766: end if;

Line 857: FROM ar_payment_schedules ps, iex_delinquencies del

853: else
854: --end moac change
855: OPEN c_overdue FOR
856: SELECT ps.acctd_amount_due_remaining
857: FROM ar_payment_schedules ps, iex_delinquencies del
858: WHERE del.delinquency_id = p_object_id
859: AND ps.payment_schedule_id = del.payment_schedule_id
860: AND ps.status = 'OP'
861: AND del.status IN ('DELINQUENT', 'PREDELINQUENT');

Line 878: FROM ar_payment_schedules ps, iex_delinquencies del

874: from ra_cm_requests cm
875: where cm.customer_trx_id in
876: (
877: SELECT distinct ps.customer_trx_id
878: FROM ar_payment_schedules ps, iex_delinquencies del
879: WHERE del.delinquency_id = p_object_id
880: AND ps.payment_schedule_id = del.payment_schedule_id
881: AND ps.status = 'OP'
882: AND del.status IN ('DELINQUENT', 'PREDELINQUENT'))

Line 953: FROM ar_payment_schedules ps, iex_delinquencies del

949: --end moac change
950:
951: OPEN c_overdue FOR
952: SELECT sum(acctd_amount_due_remaining) amount
953: FROM ar_payment_schedules ps, iex_delinquencies del
954: WHERE ps.customer_site_use_id = p_object_id
955: --BEGIN-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due
956: -- AND ps.due_date < sysdate
957: --END-FIX BUG#4356388-05/24/2005-JYPARK-amount overdue should inculde Pre-Delinquent transactions which are not past due

Line 1232: iex_delinquencies del

1228: FROM ar_payment_schedules apsa,
1229: ar_cash_receipts acr,
1230: ar_receivable_applications ara,
1231: ar_cash_receipt_history acrh,
1232: iex_delinquencies del
1233: WHERE ara.cash_receipt_id = acr.cash_receipt_id
1234: AND ara.applied_payment_schedule_id = apsa.payment_schedule_id
1235: AND apsa.payment_schedule_id = del.payment_schedule_id
1236: AND del.delinquency_id = p_object_id

Line 1519: iex_delinquencies del

1515: FROM ar_payment_schedules apsa,
1516: ar_cash_receipts acr,
1517: ar_receivable_applications ara,
1518: ar_cash_receipt_history acrh,
1519: iex_delinquencies del
1520: WHERE ara.cash_receipt_id = acr.cash_receipt_id
1521: AND ara.applied_payment_schedule_id = apsa.payment_schedule_id
1522: AND apsa.payment_schedule_id = del.payment_schedule_id
1523: AND del.delinquency_id = p_object_id

Line 1959: iex_delinquencies del,

1955: )
1956: ), 0) dso
1957: FROM ar_payment_schedules ps,
1958: hz_cust_accounts ca,
1959: iex_delinquencies del,
1960: ar_system_parameters sp
1961: WHERE ca.party_id = p_party_id
1962: AND ps.customer_id = ca.cust_account_id
1963: AND ps.status = 'OP'

Line 1972: iex_delinquencies del

1968: SELECT COUNT(DECODE(ps.class, 'INV', ps.payment_schedule_id, 'DM', ps.payment_schedule_id, 'CB', ps.payment_schedule_id, NULL)) cnt_inv,
1969: COUNT(DECODE(ps.class, 'INV', DECODE(del.status, 'DELINQUENT', del.delinquency_id, 'PREDELINQUENT', del.delinquency_id, NULL), NULL)) cnt_del
1970: FROM ar_payment_schedules ps,
1971: hz_cust_accounts ca,
1972: iex_delinquencies del
1973: WHERE ca.party_id = p_party_id
1974: AND ps.customer_id = ca.cust_account_id
1975: AND ps.status = 'OP'
1976: AND del.payment_schedule_id(+) = ps.payment_schedule_id;

Line 2018: iex_delinquencies del,

2014: )
2015: ), 0) dso
2016: FROM ar_payment_schedules ps,
2017: hz_cust_accounts ca,
2018: iex_delinquencies del,
2019: ar_system_parameters sp
2020: WHERE ca.party_id = p_party_id
2021: AND ps.customer_id = ca.cust_account_id
2022: AND ps.status = 'OP'

Line 2035: iex_delinquencies del,

2031: SUM(DECODE(del.status, 'DELINQUENT', NVL(acctd_amount_due_remaining,0),
2032: 'PREDELINQUENT', NVL(acctd_amount_due_remaining,0),0)) overdue_amt
2033: FROM ar_payment_schedules ps,
2034: hz_cust_accounts ca,
2035: iex_delinquencies del,
2036: ar_system_parameters sp
2037: WHERE ca.party_id = p_party_id
2038: AND ps.customer_id = ca.cust_account_id
2039: AND ps.status = 'OP'

Line 2047: FROM iex_delinquencies del

2043:
2044: -- Delinquencies in Past Year
2045: CURSOR c_delinquencies IS
2046: SELECT Count(1)
2047: FROM iex_delinquencies del
2048: WHERE del.party_cust_id = p_party_id
2049: AND del.creation_date between sysdate - 365 and sysdate ;
2050:
2051: -- added by jypark for status in header

Line 2227: ' FROM iex_delinquencies' ||

2223: ' AND close_date IS NULL ' ||
2224: ' AND NVL(DISPOSITION_CODE, '' '') NOT IN (''DISMISSED'',''WITHDRAWN'' )';
2225: ELSIF l_delinquency_status = 'DELINQUENT' THEN
2226: l_sql_stmt := 'SELECT count(1)' ||
2227: ' FROM iex_delinquencies' ||
2228: ' WHERE party_cust_id = :party_id' ||
2229: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
2230: ' AND status = ''DELINQUENT''';
2231:

Line 2237: ' FROM iex_litigations ltg, iex_delinquencies del' ||

2233: /*
2234: ELSIF l_delinquency_status = 'LITIGATION' THEN
2235: l_sql_stmt_lsd := 'select count(1) from (' ||
2236: ' SELECT litigation_id' ||
2237: ' FROM iex_litigations ltg, iex_delinquencies del' ||
2238: ' WHERE del.party_cust_id = :party_id' ||
2239: ' AND ltg.delinquency_id = del.delinquency_id' ||
2240: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
2241: ' AND ltg.disposition_code IS NULL ' ||

Line 2252: ' FROM iex_repossessions rps, iex_delinquencies del' ||

2248: ' AND disposition_code IS NULL )';
2249: ELSIF l_delinquency_status = 'REPOSSESSION' THEN
2250: l_sql_stmt_lsd := ' select count(1) from (' ||
2251: ' SELECT repossession_id' ||
2252: ' FROM iex_repossessions rps, iex_delinquencies del' ||
2253: ' WHERE del.party_cust_id = :party_id' ||
2254: ' AND rps.delinquency_id = del.delinquency_id' ||
2255: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
2256: ' AND (rps.disposition_code IS NULL or rps.disposition_code = ''A'' or rps.disposition_code = ''W'') ' ||

Line 2269: ' FROM iex_writeoffs wrf, iex_delinquencies del' ||

2265: -- Bug 766183 ' AND disposition_code IS NULL )';
2266: ELSIF l_delinquency_status = 'WRITEOFF' THEN
2267: l_sql_stmt_lsd := ' select count(1) from (' ||
2268: ' SELECT writeoff_id' ||
2269: ' FROM iex_writeoffs wrf, iex_delinquencies del' ||
2270: ' WHERE del.party_cust_id = :party_id' ||
2271: ' AND wrf.delinquency_id = del.delinquency_id' ||
2272: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
2273: ' AND (wrf.disposition_code IS NULL or wrf.disposition_code = ''A'' or wrf.disposition_code = ''W'') ' ||

Line 2302: ' FROM iex_delinquencies' ||

2298: ' AND (wrf.disposition_code IS NULL or wrf.disposition_code = ''A'' or wrf.disposition_code = ''W'') ' ;
2299:
2300: ELSIF l_delinquency_status = 'PREDELINQUENT' THEN
2301: l_sql_stmt := 'SELECT count(1)' ||
2302: ' FROM iex_delinquencies' ||
2303: ' WHERE party_cust_id = :party_id' ||
2304: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
2305: ' AND status = ''PREDELINQUENT''';
2306: END IF;

Line 2354: ' FROM iex_delinquencies' ||

2350: ' AND close_date IS NULL ' ||
2351: ' AND NVL(DISPOSITION_CODE , '' '') NOT IN (''DISMISSED'',''WITHDRAWN'' )';
2352: ELSIF l_delinquency_status = 'DELINQUENT' THEN
2353: l_sql_stmt := 'SELECT count(1)' ||
2354: ' FROM iex_delinquencies' ||
2355: ' WHERE party_cust_id = :party_id' ||
2356: -- fix bug #4157131 ' AND status not in (''CURRENT'', ''CLOSE'')';
2357: ' AND status = ''DELINQUENT''';
2358:

Line 2364: ' FROM iex_litigations ltg, iex_delinquencies del' ||

2360: /*
2361: ELSIF l_delinquency_status = 'LITIGATION' THEN
2362: l_sql_stmt_lsd := 'select count(1) from (' ||
2363: ' SELECT litigation_id' ||
2364: ' FROM iex_litigations ltg, iex_delinquencies del' ||
2365: ' WHERE del.party_cust_id = :party_id' ||
2366: ' AND ltg.delinquency_id = del.delinquency_id' ||
2367: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
2368: ' AND ltg.disposition_code IS NULL ' ||

Line 2379: ' FROM iex_repossessions rps, iex_delinquencies del' ||

2375: ' AND disposition_code IS NULL )';
2376: ELSIF l_delinquency_status = 'REPOSSESSION' THEN
2377: l_sql_stmt_lsd := ' select count(1) from (' ||
2378: ' SELECT repossession_id' ||
2379: ' FROM iex_repossessions rps, iex_delinquencies del' ||
2380: ' WHERE del.party_cust_id = :party_id' ||
2381: ' AND rps.delinquency_id = del.delinquency_id' ||
2382: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
2383: ' AND (rps.disposition_code IS NULL or rps.disposition_code = ''A'' or rps.disposition_code = ''W'') ' ||

Line 2396: ' FROM iex_writeoffs wrf, iex_delinquencies del' ||

2392: -- Bug 766183 ' AND disposition_code IS NULL )';
2393: ELSIF l_delinquency_status = 'WRITEOFF' THEN
2394: l_sql_stmt_lsd := ' select count(1) from (' ||
2395: ' SELECT writeoff_id' ||
2396: ' FROM iex_writeoffs wrf, iex_delinquencies del' ||
2397: ' WHERE del.party_cust_id = :party_id' ||
2398: ' AND wrf.delinquency_id = del.delinquency_id' ||
2399: ' AND del.status not in (''CURRENT'', ''CLOSE'')' ||
2400: ' AND (wrf.disposition_code IS NULL or wrf.disposition_code = ''A'' or wrf.disposition_code = ''W'') ' ||

Line 2430: ' FROM iex_delinquencies' ||

2426:
2427: -- fix bug #4157131
2428: ELSIF l_delinquency_status = 'PREDELINQUENT' THEN
2429: l_sql_stmt := 'SELECT count(1)' ||
2430: ' FROM iex_delinquencies' ||
2431: ' WHERE party_cust_id = :party_id' ||
2432: ' AND status = ''PREDELINQUENT''';
2433: END IF;
2434: