1125: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
1126: and not exists(select 1
1127: from iex_promise_details pd,
1128: gl_sets_of_books gl,
1129: ar_system_parameters_all sys
1130: where pd.delinquency_id=del.delinquency_id
1131: and pd.status='COLLECTABLE'
1132: AND pd.state = 'PROMISE' -- Bug 16175748 bibeura
1133: and gl.set_of_books_id = sys.set_of_books_id
1157: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
1158: and not exists(select 1
1159: from iex_promise_details pd,
1160: gl_sets_of_books gl,
1161: ar_system_parameters_all sys
1162: where pd.delinquency_id=del.delinquency_id
1163: and pd.status='COLLECTABLE'
1164: AND pd.state = 'PROMISE' -- Bug 16175748 bibeura
1165: and gl.set_of_books_id = sys.set_of_books_id
1189: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
1190: and not exists(select 1
1191: from iex_promise_details pd,
1192: gl_sets_of_books gl,
1193: ar_system_parameters_all sys
1194: where pd.delinquency_id=del.delinquency_id
1195: and pd.status='COLLECTABLE'
1196: AND pd.state = 'PROMISE' -- Bug 16175748 bibeura
1197: and gl.set_of_books_id = sys.set_of_books_id
1221: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
1222: and not exists(select 1
1223: from iex_promise_details pd,
1224: gl_sets_of_books gl,
1225: ar_system_parameters_all sys
1226: where pd.delinquency_id=del.delinquency_id
1227: and pd.status='COLLECTABLE'
1228: AND pd.state = 'PROMISE' -- Bug 16175748 bibeura
1229: and gl.set_of_books_id = sys.set_of_books_id