APPS.CN_COLLECTION_GEN dependencies on CN_TABLE_MAP_OBJECTS

Line 1569: FROM cn_table_map_objects tmov, cn_objects obj

1565: END IF;
1566:
1567: SELECT OBJ.name OBJECT_NAME
1568: INTO l_package_name
1569: FROM cn_table_map_objects tmov, cn_objects obj
1570: WHERE tmov.table_map_id = x_table_map_id
1571: AND tmov.tm_object_type = 'PKS'
1572: and tmov.org_id = obj.org_id
1573: and tmov.object_id = obj.object_id

Line 1682: FROM cn_table_map_objects tmov, cn_objects obj

1678: (SELECT
1679: UPPER(OBJ.name) NAME ,
1680: MAX(DECODE(tmov.tm_object_type,'PKS',tmov.object_id,NULL)) spec_id,
1681: MAX(DECODE(tmov.tm_object_type,'PKB',tmov.object_id,NULL)) body_id
1682: FROM cn_table_map_objects tmov, cn_objects obj
1683: WHERE tmov.tm_object_type IN ('PKS','PKB')
1684: and obj.object_id = tmov.object_id
1685: and tmov.org_id = obj.org_id
1686: AND tmov.table_map_id = p_table_map_id

Line 1738: FROM cn_table_map_objects tmov, cn_objects obj

1734: --+
1735: FOR obj_rec IN
1736: (SELECT
1737: DISTINCT UPPER(OBJ.name) NAME
1738: FROM cn_table_map_objects tmov, cn_objects obj
1739: WHERE tm_object_type IN ('PKS','PKB')
1740: AND tmov.table_map_id = p_table_map_id
1741: and tmov.object_id = obj.object_id
1742: and tmov.org_id = obj.org_id

Line 1775: FROM cn_table_map_objects tmov, cn_objects obj

1771: x_org_id => X_org_id);
1772: FOR pkg_names IN
1773: (SELECT
1774: DISTINCT UPPER(OBJ.name) NAME
1775: FROM cn_table_map_objects tmov, cn_objects obj
1776: WHERE tm_object_type IN ('PKS','PKB')
1777: AND tmov.table_map_id = p_table_map_id
1778: and tmov.object_id = obj.object_id
1779: and tmov.org_id = obj.org_id

Line 1819: FROM cn_table_map_objects tmov, cn_objects obj

1815: IF p_test = 'N' and x_retcode=1 THEN
1816: FOR pkg_names IN
1817: (SELECT
1818: DISTINCT UPPER(OBJ.name) NAME
1819: FROM cn_table_map_objects tmov, cn_objects obj
1820: WHERE tm_object_type IN ('PKS','PKB')
1821: AND tmov.table_map_id = p_table_map_id
1822: and tmov.object_id = obj.object_id
1823: and tmov.org_id = obj.org_id