APPS.HZ_IMP_DQM_STAGE dependencies on ALL_OBJECTS

Line 499: select owner into l_owner from sys.all_objects

495: l_owner1 VARCHAR2(255);
496: l_temp VARCHAR2(255);
497: BEGIN
498: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
499: select owner into l_owner from sys.all_objects
500: where object_name = p_object_name and OBJECT_TYPE = p_object_type and owner = l_owner1;
501: END IF;
502: RETURN l_owner;
503: EXCEPTION WHEN OTHERS THEN

Line 583: /*select owner into l_owner from sys.all_objects

579: IF (l_b = 'Y') THEN
580: IF ((l_a = 'Y') AND (l_c = l_d) ) THEN
581: IF (l_e = 'Y') THEN
582: IF (fnd_installation.GET_APP_INFO('AR',l_status,l_temp,l_owner1)) THEN
583: /*select owner into l_owner from sys.all_objects
584: where object_name = 'HZ_SRCH_PSITES' and OBJECT_TYPE = 'TABLE' and owner = l_owner1 ;*/
585: --Bug:4956084
586: l_sqlstr := 'select owner from sys.all_tables
587: where table_name = ''HZ_SRCH_PSITES'' and owner = :p_owner ';