APPS.IEX_DELINQUENCY_PUB dependencies on IEX_CASES_ALL_B

Line 1230: FROM iex_cases_all_b ic,

1226: and idb.request_id = p_request_id ;
1227: */
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

Line 1319: UPDATE IEX_CASES_ALL_B

1315: request_id = p_request_id
1316: WHERE delinquency_id = vt_del_id(v_count);
1317: */
1318: FORALL v_count in 1..vt_case_id.count
1319: UPDATE IEX_CASES_ALL_B
1320: SET status_code = vt_buf_status(v_count),
1321: last_update_date = v_today,
1322: last_updated_by = v_user_id,
1323: object_version_number = object_version_number + 1,