APPS.IEX_CUST_OVERVIEW_PVT dependencies on IEX_BANKRUPTCIES

Line 223: ' FROM iex_bankruptcies' ||

219: l_delinquency_status := r_rule.delinquency_status;
220: iex_debug_pub.LogMessage('1. l_delinquency_status :' || l_delinquency_status);
221: IF l_delinquency_status = 'BANKRUPTCY' THEN
222: l_sql_stmt := 'SELECT count(1)' ||
223: ' FROM iex_bankruptcies' ||
224: ' WHERE party_id = :party_id' ||
225: ' AND close_date IS NULL ' ||
226: ' AND NVL(DISPOSITION_CODE, '' '') NOT IN (''DISMISSED'',''WITHDRAWN'' )';
227: ELSIF l_delinquency_status = 'DELINQUENT' THEN

Line 350: ' FROM iex_bankruptcies' ||

346: l_delinquency_status := r_rule.delinquency_status;
347: iex_debug_pub.LogMessage('2. l_delinquency_status :' || l_delinquency_status);
348: IF l_delinquency_status = 'BANKRUPTCY' THEN
349: l_sql_stmt := 'SELECT count(1)' ||
350: ' FROM iex_bankruptcies' ||
351: ' WHERE party_id = :party_id' ||
352: ' AND close_date IS NULL ' ||
353: ' AND NVL(DISPOSITION_CODE , '' '') NOT IN (''DISMISSED'',''WITHDRAWN'' )';
354: ELSIF l_delinquency_status = 'DELINQUENT' THEN

Line 463: FROM iex_bankruptcies

459: -- Start for bug#7830847 by PNAVEENK on 27-1-2009
460: IF x_customer_info_rec.status IS NULL THEN
461:
462: SELECT count(1) into l_bkr_count
463: FROM iex_bankruptcies
464: WHERE party_id = x_customer_info_rec.party_id
465: AND close_date IS NULL
466: AND NVL(DISPOSITION_CODE, ' ') NOT IN ('DISMISSED','WITHDRAWN' );
467: IF l_bkr_count > 0 then

Line 2221: ' FROM iex_bankruptcies' ||

2217: l_delinquency_status := r_rule.delinquency_status;
2218: iex_debug_pub.LogMessage('3. l_delinquency_status :' || l_delinquency_status);
2219: IF l_delinquency_status = 'BANKRUPTCY' THEN
2220: l_sql_stmt := 'SELECT count(1)' ||
2221: ' FROM iex_bankruptcies' ||
2222: ' WHERE party_id = :party_id' ||
2223: ' AND close_date IS NULL ' ||
2224: ' AND NVL(DISPOSITION_CODE, '' '') NOT IN (''DISMISSED'',''WITHDRAWN'' )';
2225: ELSIF l_delinquency_status = 'DELINQUENT' THEN

Line 2348: ' FROM iex_bankruptcies' ||

2344: l_delinquency_status := r_rule.delinquency_status;
2345: iex_debug_pub.LogMessage('4. l_delinquency_status :' || l_delinquency_status);
2346: IF l_delinquency_status = 'BANKRUPTCY' THEN
2347: l_sql_stmt := 'SELECT count(1)' ||
2348: ' FROM iex_bankruptcies' ||
2349: ' WHERE party_id = :party_id' ||
2350: ' AND close_date IS NULL ' ||
2351: ' AND NVL(DISPOSITION_CODE , '' '') NOT IN (''DISMISSED'',''WITHDRAWN'' )';
2352: ELSIF l_delinquency_status = 'DELINQUENT' THEN

Line 2461: FROM iex_bankruptcies

2457: -- Start for bug#7590635 by PNAVEENK on 6-2-2009
2458: IF x_customer_info_rec.status IS NULL THEN
2459:
2460: SELECT count(1) into l_bkr_count
2461: FROM iex_bankruptcies
2462: WHERE party_id = x_customer_info_rec.party_id
2463: AND close_date IS NULL
2464: AND NVL(DISPOSITION_CODE, ' ') NOT IN ('DISMISSED','WITHDRAWN' );
2465: IF l_bkr_count > 0 then