[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
1083: SELECT ico.object_id, ids.del_status, ico.delinquency_status
1084: BULK COLLECT INTO vt_contract_id, vt_buf_status, vt_del_status
1085: FROM iex_case_objects ico,
1086: iex_del_buffers idb,
1087: iex_del_statuses ids
1088: WHERE idb.score_id = ids.score_id
1089: AND idb.score_value BETWEEN ids.score_value_low and ids.score_value_high
1090: AND idb.score_object_id = ico.object_id
1091: AND ico.object_code = 'CONTRACTS'
1214: vt_del_status,
1215: vt_case_id
1216: FROM iex_delinquencies id,
1217: iex_del_buffers idb,
1218: iex_del_statuses ids
1219: where
1220: NOT EXISTS
1221: (select 1
1222: from dual
1231: SELECT ic.cas_id, ids.del_status, ic.status_code
1232: BULK COLLECT INTO vt_case_id, vt_buf_status, vt_del_status
1233: FROM iex_cases_all_b ic,
1234: iex_del_buffers idb,
1235: iex_del_statuses ids
1236: WHERE idb.score_id = ids.score_id
1237: AND idb.score_value BETWEEN ids.score_value_low and ids.score_value_high
1238: AND idb.score_object_id = ic.cas_id
1239: AND idb.request_id = p_request_id;
1440: IEX_CASES_VL ICV,
1441: IEX_CASE_DEFINITIONS ICD,
1442: IEX_CASES_VL ICV2,
1443: IEX_CASE_DEFINITIONS ICD2,
1444: IEX_DEL_STATUSES IDS
1445: WHERE
1446: NOT EXISTS
1447: (Select 1
1448: from iex_delinquencies