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 326: ' FROM iex_bankruptcies' ||

322: l_delinquency_status := r_rule.delinquency_status;
323: iex_debug_pub.LogMessage('2. l_delinquency_status :' || l_delinquency_status);
324: IF l_delinquency_status = 'BANKRUPTCY' THEN
325: l_sql_stmt := 'SELECT count(1)' ||
326: ' FROM iex_bankruptcies' ||
327: ' WHERE party_id = :party_id' ||
328: ' AND close_date IS NULL ' ||
329: ' AND NVL(DISPOSITION_CODE , '' '') NOT IN (''DISMISSED'',''WITHDRAWN'' )';
330: ELSIF l_delinquency_status = 'DELINQUENT' THEN

Line 416: FROM iex_bankruptcies

412: -- Start for bug#7830847 by PNAVEENK on 27-1-2009
413: IF x_customer_info_rec.status IS NULL THEN
414:
415: SELECT count(1) into l_bkr_count
416: FROM iex_bankruptcies
417: WHERE party_id = x_customer_info_rec.party_id
418: AND close_date IS NULL
419: AND NVL(DISPOSITION_CODE, ' ') NOT IN ('DISMISSED','WITHDRAWN' );
420: IF l_bkr_count > 0 then

Line 2080: ' FROM iex_bankruptcies' ||

2076: l_delinquency_status := r_rule.delinquency_status;
2077: iex_debug_pub.LogMessage('3. l_delinquency_status :' || l_delinquency_status);
2078: IF l_delinquency_status = 'BANKRUPTCY' THEN
2079: l_sql_stmt := 'SELECT count(1)' ||
2080: ' FROM iex_bankruptcies' ||
2081: ' WHERE party_id = :party_id' ||
2082: ' AND close_date IS NULL ' ||
2083: ' AND NVL(DISPOSITION_CODE, '' '') NOT IN (''DISMISSED'',''WITHDRAWN'' )';
2084: ELSIF l_delinquency_status = 'DELINQUENT' THEN

Line 2184: ' FROM iex_bankruptcies' ||

2180: l_delinquency_status := r_rule.delinquency_status;
2181: iex_debug_pub.LogMessage('4. l_delinquency_status :' || l_delinquency_status);
2182: IF l_delinquency_status = 'BANKRUPTCY' THEN
2183: l_sql_stmt := 'SELECT count(1)' ||
2184: ' FROM iex_bankruptcies' ||
2185: ' WHERE party_id = :party_id' ||
2186: ' AND close_date IS NULL ' ||
2187: ' AND NVL(DISPOSITION_CODE , '' '') NOT IN (''DISMISSED'',''WITHDRAWN'' )';
2188: ELSIF l_delinquency_status = 'DELINQUENT' THEN