DBA Data[Home] [Help]

APPS.IEX_DELINQUENCY_PUB dependencies on IEX_CASE_OBJECTS

Line 1082: FROM iex_case_objects ico,

1078: END IF;
1079:
1080: SELECT ico.object_id, ids.del_status, ico.delinquency_status
1081: BULK COLLECT INTO vt_contract_id, vt_buf_status, vt_del_status
1082: FROM iex_case_objects ico,
1083: iex_del_buffers idb,
1084: iex_del_statuses ids
1085: WHERE idb.score_id = ids.score_id
1086: AND idb.score_value BETWEEN ids.score_value_low and ids.score_value_high

Line 1141: UPDATE IEX_CASE_OBJECTS

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