DBA Data[Home] [Help]

APPS.IEX_DELINQUENCY_PUB dependencies on IEX_CASE_OBJECTS

Line 1085: FROM iex_case_objects ico,

1081: END IF;
1082:
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

Line 1144: UPDATE IEX_CASE_OBJECTS

1140:
1141: begin
1142:
1143: FORALL v_count in 1..vt_contract_id.count
1144: UPDATE IEX_CASE_OBJECTS
1145: SET delinquency_status = vt_buf_status(v_count),
1146: last_update_date = v_today,
1147: last_updated_by = v_user_id,
1148: object_version_number = object_version_number + 1,