DBA Data[Home] [Help]

APPS.AS_OPP_LINE_PVT dependencies on AS_INTEREST_TYPES_B

Line 292: FROM as_interest_types_b

288: )
289: Is
290: CURSOR C_Int_Type_Exists (X_Int_Type_Id NUMBER) IS
291: SELECT 'X'
292: FROM as_interest_types_b
293: WHERE Interest_Type_Id = X_Int_Type_Id;
294:
295: CURSOR C_Prim_Int_Code_Exists (X_Int_Code_Id NUMBER,
296: X_Int_Type_Id NUMBER) IS

Line 563: from AS_INTEREST_TYPES_B

559: and inventory_item_id=l_item_id;
560:
561: CURSOR C_GET_CATEGORY_FROM_IT(c_interest_type_id NUMBER) IS
562: select product_category_id, product_cat_set_id
563: from AS_INTEREST_TYPES_B
564: where interest_type_id = c_interest_type_id;
565:
566: CURSOR C_GET_CATEGORY_FROM_PIC(c_interest_type_id NUMBER, c_interest_code_id NUMBER) IS
567: select product_category_id, product_cat_set_id