APPS.PA_ADW_COLLECT_MAIN dependencies on PA_CLASS_CODES

Line 166: UPDATE PA_CLASS_CODES SET ADW_NOTIFY_FLAG='Y'

162:
163: UPDATE PA_CLASS_CATEGORIES SET ADW_NOTIFY_FLAG='Y'
164: WHERE ADW_NOTIFY_FLAG = 'N';
165:
166: UPDATE PA_CLASS_CODES SET ADW_NOTIFY_FLAG='Y'
167: WHERE ADW_NOTIFY_FLAG = 'N';
168:
169: UPDATE PA_PROJECT_CLASSES SET ADW_NOTIFY_FLAG='Y'
170: WHERE ADW_NOTIFY_FLAG = 'N';

Line 221: DELETE FROM PA_CLASS_CODES_IT;

217: DELETE FROM PA_PRJ_TYPES_IT;
218: DELETE FROM PA_EXP_TYPES_IT;
219: DELETE FROM PA_PRJ_CLASSES_IT;
220: DELETE FROM PA_CLASS_CATGS_IT;
221: DELETE FROM PA_CLASS_CODES_IT;
222: DELETE FROM PA_LOWEST_RLMEM_IT;
223: DELETE FROM PA_TOP_RLMEM_IT;
224: DELETE FROM PA_RES_LISTS_IT;
225: DELETE FROM PA_SRVC_TYPES_IT;

Line 443: DELETE FROM PA_CLASS_CODES_IT

439:
440: DELETE FROM PA_CLASS_CATGS_IT
441: WHERE STATUS_CODE = 'T';
442:
443: DELETE FROM PA_CLASS_CODES_IT
444: WHERE STATUS_CODE = 'T';
445:
446: DELETE FROM PA_LOWEST_RLMEM_IT
447: WHERE STATUS_CODE = 'T';