[Home] [Help]
455: IDS.del_status
456: FROM HZ_CUST_ACCOUNTS HZCA,
457: IEX_DEL_BUFFERS IDB,
458: AR_PAYMENT_SCHEDULES ARPS,
459: IEX_DEL_STATUSES IDS
460: WHERE
461: NOT EXISTS
462: (Select 1
463: from iex_delinquencies
489: id.status del_status,
490: id.payment_schedule_id
491: FROM iex_delinquencies id,
492: iex_del_buffers idb,
493: iex_del_statuses ids
494: where NOT EXISTS
495: (select 1
496: from dual
497: where id.status = ids.del_status)
644: From dual ;
645:
646: Select count(1)
647: into v_score_range
648: from iex_del_statuses
649: where score_id = v_score ;
650:
651: -- IF PG_DEBUG < 10 THEN
652: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
696: vt_del_status,
697: vt_pmt_schd_id
698: FROM iex_delinquencies id,
699: iex_del_buffers idb,
700: iex_del_statuses ids
701: where NOT EXISTS
702: (select 1
703: from dual
704: -- Begin - Andre Araujo - 12/21/2004 - Remove the pre-del 2 del constraint bug#4072687
983: p_Request_id
984: FROM HZ_CUST_ACCOUNTS HZCA ,
985: IEX_DEL_BUFFERS IDB ,
986: AR_PAYMENT_SCHEDULES ARPS ,
987: IEX_DEL_STATUSES IDS
988: WHERE
989: NOT EXISTS
990: (Select 1
991: from iex_delinquencies_all --added by barathsr for bug#7366451 10-Oct-08
1080: SELECT ico.object_id, ids.del_status, ico.delinquency_status
1081: BULK COLLECT INTO vt_contract_id, vt_buf_status, vt_del_status
1082: FROM iex_case_objects ico,
1083: iex_del_buffers idb,
1084: iex_del_statuses ids
1085: WHERE idb.score_id = ids.score_id
1086: AND idb.score_value BETWEEN ids.score_value_low and ids.score_value_high
1087: AND idb.score_object_id = ico.object_id
1088: AND ico.object_code = 'CONTRACTS'
1211: vt_del_status,
1212: vt_case_id
1213: FROM iex_delinquencies id,
1214: iex_del_buffers idb,
1215: iex_del_statuses ids
1216: where
1217: NOT EXISTS
1218: (select 1
1219: from dual
1228: SELECT ic.cas_id, ids.del_status, ic.status_code
1229: BULK COLLECT INTO vt_case_id, vt_buf_status, vt_del_status
1230: FROM iex_cases_all_b ic,
1231: iex_del_buffers idb,
1232: iex_del_statuses ids
1233: WHERE idb.score_id = ids.score_id
1234: AND idb.score_value BETWEEN ids.score_value_low and ids.score_value_high
1235: AND idb.score_object_id = ic.cas_id
1236: AND idb.request_id = p_request_id;
1437: IEX_CASES_VL ICV,
1438: IEX_CASE_DEFINITIONS ICD,
1439: IEX_CASES_VL ICV2,
1440: IEX_CASE_DEFINITIONS ICD2,
1441: IEX_DEL_STATUSES IDS
1442: WHERE
1443: NOT EXISTS
1444: (Select 1
1445: from iex_delinquencies