84: l_temp VARCHAR2(1);
85:
86: CURSOR l_instance_csr IS
87: SELECT instance_code
88: FROM EDW_LOCAL_INSTANCE;
89:
90: -- Cursor to figure out the items having same name with diff. ids
91: CURSOR c_mult_item IS
92: SELECT
387:
388: /* Bug# 2558245
389: CURSOR l_instance_csr is
390: SELECT instance_code
391: FROM edw_local_instance;
392: */
393:
394: CURSOR category_assignments_cursor IS /* Bug# 2197243 */
395: SELECT
1117:
1118: /* Bug# 2558245
1119: CURSOR l_instance_csr is
1120: SELECT instance_code
1121: FROM edw_local_instance;
1122: */
1123:
1124: l_all_item_orgs VARCHAR2(100);
1125: l_all_item_revs VARCHAR2(100);