DBA Data[Home] [Help]

APPS.CN_COLLECTION_CUSTOM_GEN dependencies on CN_TABLE_MAP_OBJECTS

Line 80: FROM cn_table_map_objects tmov, cn_objects obj

76: l_parallel_hint VARCHAR2(4000) := '/'||'*'||'+';
77:
78: CURSOR c_param IS
79: SELECT tmov.object_id, LOWER(OBJ.name) object_name
80: FROM cn_table_map_objects tmov, cn_objects obj
81: WHERE tmov.table_map_id = x_table_map_id
82: AND tmov.tm_object_type = 'PARAM'
83: and obj.object_id = tmov.object_id
84: and tmov.org_id = obj.org_id

Line 782: FROM cn_table_map_objects tmov, cn_objects obj

778: l_delete_flag VARCHAR2(1);
779: l_statement VARCHAR2(100);
780: CURSOR c_filter IS
781: SELECT OBJ.object_value
782: FROM cn_table_map_objects tmov, cn_objects obj
783: WHERE tmov.table_map_id = x_table_map_id
784: AND tmov.tm_object_type = 'FILTER'
785: and tmov.object_id = obj.object_id
786: and tmov.org_id = obj.org_id

Line 855: FROM cn_table_map_objects tmov, cn_objects obj

851: -- For every line of User Code registered for this location
852: --+
853: FOR rec IN
854: (SELECT OBJ.object_value
855: FROM cn_table_map_objects tmov, cn_objects obj
856: WHERE tmov.table_map_id = p_table_map_id
857: and obj.object_id = tmov.object_id
858: and tmov.org_id = obj.org_id
859: AND tmov.tm_object_type = 'USERCODE'