DBA Data[Home] [Help]

APPS.CN_COLLECTION_CUSTOM_GEN dependencies on CN_TABLE_MAP_OBJECTS

Line 60: FROM cn_table_map_objects tmov,

56: CURSOR c_param
57: IS
58: SELECT tmov.object_id,
59: LOWER(OBJ.name) object_name
60: FROM cn_table_map_objects tmov,
61: cn_objects obj
62: WHERE tmov.table_map_id = x_table_map_id
63: AND tmov.tm_object_type = 'PARAM'
64: AND obj.object_id = tmov.object_id

Line 689: FROM cn_table_map_objects tmov,

685: l_statement VARCHAR2(100);
686: CURSOR c_filter
687: IS
688: SELECT OBJ.object_value
689: FROM cn_table_map_objects tmov,
690: cn_objects obj
691: WHERE tmov.table_map_id = x_table_map_id
692: AND tmov.tm_object_type = 'FILTER'
693: AND tmov.object_id = obj.object_id

Line 777: FROM cn_table_map_objects tmov,

773: l_location_name := p_location_name;
774: END IF;
775: FOR rec IN
776: (SELECT OBJ.object_value
777: FROM cn_table_map_objects tmov,
778: cn_objects obj
779: WHERE tmov.table_map_id = p_table_map_id
780: AND obj.object_id = tmov.object_id
781: AND tmov.org_id = obj.org_id