APPS.IEX_STRATEGY_CNT_PUB dependencies on IEX_PROMISE_DETAILS

Line 1190: not exists (select 1 from iex_promise_details p

1186: where s.strategy_level = 10 and
1187: s.status_code = 'ONHOLD' and
1188: d.status in ('DELINQUENT','PREDELINQUENT') and
1189: d.party_cust_id = s.party_id and
1190: not exists (select 1 from iex_promise_details p
1191: where p.status='COLLECTABLE'
1192: AND d.delinquency_id=p.delinquency_id)
1193: and nvl(s.org_id,-99) = decode(l_org_enabled,'Y',l_org_id,nvl(s.org_id,-99))
1194: group by s.strategy_id, s.strategy_template_id, S.STATUS_CODE,d.party_cust_id;

Line 1206: not exists (select 1 from iex_promise_details p

1202: where s.strategy_level = 20 and
1203: s.status_code = 'ONHOLD' and
1204: d.status in ('DELINQUENT','PREDELINQUENT') and
1205: d.CUST_ACCOUNT_id = s.CUST_ACCOUNT_id and
1206: not exists (select 1 from iex_promise_details p
1207: where p.status='COLLECTABLE'
1208: AND d.delinquency_id=p.delinquency_id)
1209: and nvl(s.org_id,-99) = decode(l_org_enabled,'Y',l_org_id,nvl(s.org_id,-99))
1210: group by s.strategy_id, s.strategy_template_id, S.STATUS_CODE,d.cust_account_id;

Line 1222: not exists (select 1 from iex_promise_details p

1218: where s.strategy_level = 30 and
1219: s.status_code = 'ONHOLD' and
1220: d.status in ('DELINQUENT','PREDELINQUENT') and
1221: d.customer_site_use_id = s.customer_site_use_id and
1222: not exists (select 1 from iex_promise_details p
1223: where p.status='COLLECTABLE'
1224: AND d.delinquency_id=p.delinquency_id)
1225: and nvl(s.org_id,-99) = decode(l_org_enabled,'Y',l_org_id,nvl(s.org_id,-99))
1226: group by s.strategy_id, s.strategy_template_id, S.STATUS_CODE,d.customer_site_use_id;