APPS.AMW_LOAD_RC_DATA dependencies on AMW_LATEST_REVISIONS_V

Line 473: FROM AMW_LATEST_REVISIONS_V

469: --PROCESS_NAME, ORG_ID ARE ALWAYS NON-NULL
470: --PROCESS_CODE CAN BE NULL
471: IF(VALID_REC.PROCESS_CODE IS NULL) THEN
472: SELECT PROCESS_CODE,PROCESS_ID INTO L_PROCESS_CODE,L_PROCESS_ID
473: FROM AMW_LATEST_REVISIONS_V
474: WHERE DISPLAY_NAME=VALID_REC.PROCESS_NAME;
475: ELSE
476: SELECT PROCESS_CODE,PROCESS_ID INTO L_PROCESS_CODE,L_PROCESS_ID
477: FROM AMW_LATEST_REVISIONS_V

Line 477: FROM AMW_LATEST_REVISIONS_V

473: FROM AMW_LATEST_REVISIONS_V
474: WHERE DISPLAY_NAME=VALID_REC.PROCESS_NAME;
475: ELSE
476: SELECT PROCESS_CODE,PROCESS_ID INTO L_PROCESS_CODE,L_PROCESS_ID
477: FROM AMW_LATEST_REVISIONS_V
478: WHERE DISPLAY_NAME=VALID_REC.PROCESS_NAME
479: AND PROCESS_CODE=VALID_REC.PROCESS_CODE;
480: END IF;
481: EXCEPTION

Line 552: from amw_latest_revisions_v

548: --executing these if blocks as before
549: if(rc_rec.process_code is null)then
550: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_interface_id: '||v_interface_id||', process_code is null --> display_name: '||rc_rec.process_name);
551: select process_id into l_process_id
552: from amw_latest_revisions_v
553: where display_name=rc_rec.process_name;
554: else
555: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_interface_id: '||v_interface_id||', process_code is exists --> display_name: '||rc_rec.process_name||', process_code: '||rc_rec.process_code);
556: select process_id into l_process_id

Line 557: from amw_latest_revisions_v

553: where display_name=rc_rec.process_name;
554: else
555: FND_FILE.PUT_LINE(FND_FILE.LOG, 'v_interface_id: '||v_interface_id||', process_code is exists --> display_name: '||rc_rec.process_name||', process_code: '||rc_rec.process_code);
556: select process_id into l_process_id
557: from amw_latest_revisions_v
558: where display_name=rc_rec.process_name
559: and process_code=rc_rec.process_code;
560: end if;
561: end if; --end of npanandi check 12.09.2004