APPS.AS_CATALOG_MIGRATION dependencies on AS_INTEREST_CODES_TL

Line 142: from as_interest_codes_b B, as_interest_codes_tl TL

138:
139:
140: CURSOR C_Get_Pri_Int_Code(c_interest_type_id Number) IS
141: select B.interest_code_id, TL.code, TL.description,B.enabled_flag
142: from as_interest_codes_b B, as_interest_codes_tl TL
143: where B.interest_code_id = TL.interest_code_id
144: and TL.language = userenv('LANG')
145: and B.interest_type_id = c_interest_type_id
146: and B.parent_interest_code_id is null;

Line 150: from as_interest_codes_b B, as_interest_codes_tl TL

146: and B.parent_interest_code_id is null;
147:
148: CURSOR C_Get_Sec_Int_Code(c_interest_code_id Number) IS
149: select B.interest_code_id, TL.code, TL.description,B.enabled_flag
150: from as_interest_codes_b B, as_interest_codes_tl TL
151: where B.interest_code_id = TL.interest_code_id
152: and TL.language = userenv('LANG')
153: and B.parent_interest_code_id = c_interest_code_id;
154: