APPS.AMW_LOAD_RCM_ORG_DATA dependencies on AMW_LATEST_REV_ORG_V

Line 472: FROM AMW_LATEST_REV_ORG_V

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

Line 477: FROM AMW_LATEST_REV_ORG_V

473: WHERE ORGANIZATION_ID=VALID_REC.ORGANIZATION_ID
474: AND 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_REV_ORG_V
478: WHERE ORGANIZATION_ID=VALID_REC.ORGANIZATION_ID
479: AND DISPLAY_NAME=VALID_REC.PROCESS_NAME
480: AND PROCESS_CODE=VALID_REC.PROCESS_CODE;
481: END IF;

Line 555: from amw_latest_rev_org_v

551: if(rc_rec.process_code is not null and rc_rec.process_name is not null)then
552: begin
553: 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);
554: select process_id into l_process_id
555: from amw_latest_rev_org_v
556: where display_name=rc_rec.process_name
557: and process_code=rc_rec.process_code
558: and organization_id=rc_rec.organization_id;
559: exception