...
Determine which application is being referred to by running the attached query in TOAD, replacing the text “INSERT_TC_USER_ID” with the user’s TC User ID.
See script below
From the list of results, determine which application is the one to be removed. There is usually only one application with Pending Tasks, but not always. If need be, confirm with the client. Appplicaion Date is a good reference point.
Once the application to be removed has been identified, get the relative application_id and related_application_id values from the list of results.
In TOAD, go to table UA019_TASK and locate any records with ALL RECORDS where ua019_task.applicaion_id is equal to either the application_id or related_application_id valuesvalue from #3 above. Update the value for TASK_STATUS_CD to 3 (Declined). Note: Under the tc_user schema in TOAD for TCIDP tables will be listed under Synonyms.
In TOAD, go to table AA009_APPLICATION and locate any records (max. 2) with the application_id or related_application_id values. Update the value for TASK_STATUS_CD aa009_application.application_status_cd to 3 (Declined).
Notify user.
...