APPS.JTF_TTY_PROD_CAT_MIGRATE_PVT dependencies on AS_INTEREST_TYPES_B

Line 94: FROM as_interest_types_b int

90: FORALL j IN l_terr_val_ids_arr.FIRST..l_terr_val_ids_arr.LAST
91: UPDATE jtf_terr_values_all jtv
92: SET (value1_id, value2_id) =
93: (SELECT int.product_category_id, int.product_cat_set_id
94: FROM as_interest_types_b int
95: WHERE jtv.interest_type_id = int.interest_type_id)
96: WHERE jtv.terr_value_id = l_terr_val_ids_arr(j);
97: if (upper(p_Debug_Flag) = 'Y') then
98: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interest Types: Rows migrated: ' || SQL%ROWCOUNT);

Line 268: FROM as_interest_types_b int

264:
265: UPDATE jtf_tty_role_prod_int jtr
266: SET (product_category_id, product_category_set_id) =
267: (SELECT int.product_category_id, int.product_cat_set_id
268: FROM as_interest_types_b int
269: WHERE jtr.interest_type_id = int.interest_type_id);
270: COMMIT;
271:
272: if (upper(p_Debug_Flag) = 'Y') then