APPS.CN_COLLECTION_GEN dependencies on CN_TABLE_MAP_OBJECTS

Line 1510: FROM cn_table_map_objects tmov, cn_objects obj

1506: END IF;
1507:
1508: SELECT OBJ.name OBJECT_NAME
1509: INTO l_package_name
1510: FROM cn_table_map_objects tmov, cn_objects obj
1511: WHERE tmov.table_map_id = x_table_map_id
1512: AND tmov.tm_object_type = 'PKS'
1513: and tmov.org_id = obj.org_id
1514: and tmov.object_id = obj.object_id

Line 1617: FROM cn_table_map_objects tmov, cn_objects obj

1613: (SELECT
1614: UPPER(OBJ.name) NAME ,
1615: MAX(DECODE(tmov.tm_object_type,'PKS',tmov.object_id,NULL)) spec_id,
1616: MAX(DECODE(tmov.tm_object_type,'PKB',tmov.object_id,NULL)) body_id
1617: FROM cn_table_map_objects tmov, cn_objects obj
1618: WHERE tmov.tm_object_type IN ('PKS','PKB')
1619: and obj.object_id = tmov.object_id
1620: and tmov.org_id = obj.org_id
1621: AND tmov.table_map_id = p_table_map_id

Line 1673: FROM cn_table_map_objects tmov, cn_objects obj

1669: --+
1670: FOR obj_rec IN
1671: (SELECT
1672: DISTINCT UPPER(OBJ.name) NAME
1673: FROM cn_table_map_objects tmov, cn_objects obj
1674: WHERE tm_object_type IN ('PKS','PKB')
1675: AND tmov.table_map_id = p_table_map_id
1676: and tmov.object_id = obj.object_id
1677: and tmov.org_id = obj.org_id

Line 1710: FROM cn_table_map_objects tmov, cn_objects obj

1706: x_org_id => X_org_id);
1707: FOR pkg_names IN
1708: (SELECT
1709: DISTINCT UPPER(OBJ.name) NAME
1710: FROM cn_table_map_objects tmov, cn_objects obj
1711: WHERE tm_object_type IN ('PKS','PKB')
1712: AND tmov.table_map_id = p_table_map_id
1713: and tmov.object_id = obj.object_id
1714: and tmov.org_id = obj.org_id

Line 1754: FROM cn_table_map_objects tmov, cn_objects obj

1750: IF p_test = 'N' and x_retcode=1 THEN
1751: FOR pkg_names IN
1752: (SELECT
1753: DISTINCT UPPER(OBJ.name) NAME
1754: FROM cn_table_map_objects tmov, cn_objects obj
1755: WHERE tm_object_type IN ('PKS','PKB')
1756: AND tmov.table_map_id = p_table_map_id
1757: and tmov.object_id = obj.object_id
1758: and tmov.org_id = obj.org_id