APPS.AS_CATALOG_MIGRATION dependencies on AS_INTEREST_TYPES_B

Line 135: from as_interest_types_b B, as_interest_types_tl TL

131:
132: -- Cursors
133: CURSOR C_Get_Int_Type IS
134: select B.interest_type_id, TL.interest_type, TL.description, B.Expected_Purchase_Flag,B.enabled_flag
135: from as_interest_types_b B, as_interest_types_tl TL
136: where B.interest_type_id = TL.interest_type_id
137: and TL.language = userenv('LANG');
138:
139:

Line 264: Update AS_INTEREST_TYPES_B set product_category_id = l_int_type_cat_id, product_cat_set_id = l_category_set_id where interest_type_id = scr.interest_type_id;

260: GOTO end_loop1;
261: end if;
262:
263: -- Update the mapping between interest type and product category
264: Update AS_INTEREST_TYPES_B set product_category_id = l_int_type_cat_id, product_cat_set_id = l_category_set_id where interest_type_id = scr.interest_type_id;
265:
266: -- For each primary interest code corresponding to selected interest type
267: FOR scr2 in C_Get_Pri_Int_Code(scr.interest_type_id)
268: LOOP