APPS.JTF_TTY_PROD_CAT_MIGRATE_PVT dependencies on AS_INTEREST_CODES_B

Line 124: FROM as_interest_codes_b int

120: FORALL j IN l_terr_val_ids_arr.FIRST..l_terr_val_ids_arr.LAST
121: UPDATE jtf_terr_values_all jtv
122: SET (value1_id, value2_id) =
123: (SELECT int.product_category_id, int.product_cat_set_id
124: FROM as_interest_codes_b int
125: WHERE jtv.primary_interest_code_id = int.interest_code_id)
126: WHERE jtv.terr_value_id = l_terr_val_ids_arr(j);
127: if (upper(p_Debug_Flag) = 'Y') then
128: FND_FILE.PUT_LINE(FND_FILE.LOG,'Primary Interest codes: Rows migrated: ' || SQL%ROWCOUNT);

Line 154: FROM as_interest_codes_b int

150: FORALL j IN l_terr_val_ids_arr.FIRST..l_terr_val_ids_arr.LAST
151: UPDATE jtf_terr_values_all jtv
152: SET (value1_id, value2_id) =
153: (SELECT int.product_category_id, int.product_cat_set_id
154: FROM as_interest_codes_b int
155: WHERE jtv.secondary_interest_code_id = int.interest_code_id)
156: WHERE jtv.terr_value_id = l_terr_val_ids_arr(j);
157: if (upper(p_Debug_Flag) = 'Y') then
158: FND_FILE.PUT_LINE(FND_FILE.LOG,'Secondary Interest Codes: Rows migrated: ' || SQL%ROWCOUNT);