APPS.PA_ADW_COLLECT_MAIN dependencies on PA_TASKS

Line 151: UPDATE PA_TASKS SET ADW_NOTIFY_FLAG='Y'

147: x_err_stack := x_err_stack || '-> prepare_src_table_for_refresh';
148:
149: pa_debug.debug(x_err_stage);
150:
151: UPDATE PA_TASKS SET ADW_NOTIFY_FLAG='Y'
152: WHERE ADW_NOTIFY_FLAG = 'N';
153:
154: UPDATE PA_PROJECTS SET ADW_NOTIFY_FLAG='Y'
155: WHERE ADW_NOTIFY_FLAG = 'N';