DBA Data[Home] [Help]

APPS.JAI_CMN_SETUP_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 1230: FROM JAI_CMN_VENDOR_SITES

1226: v_assessable_val NUMBER;
1227:
1228: CURSOR Fetch_Price_List_Id_Cur IS
1229: SELECT Price_List_Id
1230: FROM JAI_CMN_VENDOR_SITES
1231: WHERE Vendor_Id = p_vendor_id
1232: AND Vendor_Site_Id = NVL( p_vendor_site_id, 0 );
1233:
1234: CURSOR Fetch_Price_List1_Id_Cur IS

Line 1236: FROM JAI_CMN_VENDOR_SITES

1232: AND Vendor_Site_Id = NVL( p_vendor_site_id, 0 );
1233:
1234: CURSOR Fetch_Price_List1_Id_Cur IS
1235: SELECT Price_List_Id
1236: FROM JAI_CMN_VENDOR_SITES
1237: WHERE vendor_Id = p_vendor_id
1238: AND Vendor_Site_Id = 0;
1239:
1240: CURSOR Fetch_Assessable_Val_Cur(cp_item qp_List_Lines_v.product_attribute_context%type) IS