DBA Data[Home] [Help]

APPS.AS_INTEREST_PVT dependencies on AS_INTEREST_CODES_B

Line 1864: FROM As_Interest_Codes_B Pic

1860:
1861: CURSOR C_Prim_Int_Code_Exists (X_Int_Code_Id NUMBER,
1862: X_Int_Type_Id NUMBER) IS
1863: SELECT 'X'
1864: FROM As_Interest_Codes_B Pic
1865: WHERE Pic.Interest_Type_Id = X_Int_Type_Id
1866: and Pic.Interest_Code_Id = X_Int_Code_Id
1867: and Pic.Parent_Interest_Code_Id Is Null;
1868:

Line 1873: FROM As_Interest_Codes_B Sic

1869: CURSOR C_Sec_Int_Code_Exists (X_Sec_Int_Code_Id NUMBER,
1870: X_Int_Code_Id NUMBER,
1871: X_Int_Type_Id NUMBER) IS
1872: SELECT 'X'
1873: FROM As_Interest_Codes_B Sic
1874: WHERE Sic.Interest_Type_Id = X_Int_Type_Id
1875: And Sic.Interest_Code_Id = X_Sec_Int_Code_Id
1876: And Sic.Parent_Interest_Code_Id = X_Int_Code_Id;
1877: