DBA Data[Home] [Help]

APPS.ARP_PROGRAM_GENERATE_BR dependencies on DBA_OBJECTS

Line 4217: FROM sys.dba_objects

4213: BEGIN
4214:
4215: SELECT COUNT(object_name)
4216: INTO nb_nimm
4217: FROM sys.dba_objects
4218: WHERE object_name = table_name_nimm
4219: AND owner = l_user_schema;
4220:
4221: EXCEPTION

Line 4231: FROM sys.dba_objects

4227: BEGIN
4228:
4229: SELECT COUNT(object_name)
4230: INTO nb_imm
4231: FROM sys.dba_objects
4232: WHERE object_name = table_name_imm
4233: AND owner = l_user_schema;
4234:
4235: EXCEPTION

Line 4245: FROM sys.dba_objects

4241: BEGIN
4242:
4243: SELECT COUNT(object_name)
4244: INTO nb_aimm
4245: FROM sys.dba_objects
4246: WHERE object_name = table_name_aimm
4247: AND owner = l_user_schema;
4248:
4249: EXCEPTION

Line 4386: FROM sys.dba_objects

4382: BEGIN
4383:
4384: SELECT COUNT(object_name)
4385: INTO nb_obj
4386: FROM sys.dba_objects
4387: WHERE object_name = g_tmp_table_nimm
4388: AND owner = l_user_schema;
4389:
4390: EXCEPTION

Line 4414: FROM sys.dba_objects

4410: BEGIN
4411:
4412: SELECT COUNT(object_name)
4413: INTO nb_obj
4414: FROM sys.dba_objects
4415: WHERE object_name = g_tmp_table_imm
4416: AND owner = l_user_schema;
4417:
4418: EXCEPTION

Line 4437: FROM sys.dba_objects

4433: BEGIN
4434:
4435: SELECT COUNT(object_name)
4436: INTO nb_obj
4437: FROM sys.dba_objects
4438: WHERE object_name = g_tmp_table_aimm
4439: AND owner = l_user_schema;
4440:
4441: EXCEPTION