APPS.IEX_DELINQUENCY_PUB dependencies on IEX_CASES_ALL_B

Line 1233: FROM iex_cases_all_b ic,

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

Line 1322: UPDATE IEX_CASES_ALL_B

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