APPS.AS_OPP_LINE_PVT dependencies on AS_INTEREST_CODES_B

Line 298: FROM As_Interest_Codes_B Pic

294:
295: CURSOR C_Prim_Int_Code_Exists (X_Int_Code_Id NUMBER,
296: X_Int_Type_Id NUMBER) IS
297: SELECT 'X'
298: FROM As_Interest_Codes_B Pic
299: WHERE Pic.Interest_Type_Id = X_Int_Type_Id
300: and Pic.Interest_Code_Id = X_Int_Code_Id
301: and Pic.Parent_Interest_Code_Id Is Null;
302:

Line 307: FROM As_Interest_Codes_B Sic

303: CURSOR C_Sec_Int_Code_Exists (X_Sec_Int_Code_Id NUMBER,
304: X_Int_Code_Id NUMBER,
305: X_Int_Type_Id NUMBER) IS
306: SELECT 'X'
307: FROM As_Interest_Codes_B Sic
308: WHERE Sic.Interest_Type_Id = X_Int_Type_Id
309: And Sic.Interest_Code_Id = X_Sec_Int_Code_Id
310: And Sic.Parent_Interest_Code_Id = X_Int_Code_Id;
311:

Line 568: from AS_INTEREST_CODES_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
568: from AS_INTEREST_CODES_B
569: where interest_code_id = c_interest_code_id
570: and interest_type_id = c_interest_type_id;
571:
572: CURSOR C_GET_CATEGORY_FROM_SIC(c_interest_type_id NUMBER, c_pri_interest_code_id NUMBER, c_sec_interest_code_id NUMBER) IS

Line 574: from AS_INTEREST_CODES_B

570: and interest_type_id = c_interest_type_id;
571:
572: CURSOR C_GET_CATEGORY_FROM_SIC(c_interest_type_id NUMBER, c_pri_interest_code_id NUMBER, c_sec_interest_code_id NUMBER) IS
573: select product_category_id, product_cat_set_id
574: from AS_INTEREST_CODES_B
575: where interest_code_id = c_sec_interest_code_id
576: and interest_type_id = c_interest_type_id
577: and parent_interest_code_id = c_pri_interest_code_id;
578: