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
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
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'