DBA Data[Home] [Help]

APPS.JAI_CMN_SETUP_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 1175: FROM JAI_CMN_VENDOR_SITES

1171: v_assessable_val NUMBER;
1172:
1173: CURSOR Fetch_Price_List_Id_Cur IS
1174: SELECT Price_List_Id
1175: FROM JAI_CMN_VENDOR_SITES
1176: WHERE Vendor_Id = p_vendor_id
1177: AND Vendor_Site_Id = NVL( p_vendor_site_id, 0 );
1178:
1179: CURSOR Fetch_Price_List1_Id_Cur IS

Line 1181: FROM JAI_CMN_VENDOR_SITES

1177: AND Vendor_Site_Id = NVL( p_vendor_site_id, 0 );
1178:
1179: CURSOR Fetch_Price_List1_Id_Cur IS
1180: SELECT Price_List_Id
1181: FROM JAI_CMN_VENDOR_SITES
1182: WHERE vendor_Id = p_vendor_id
1183: AND Vendor_Site_Id = 0;
1184:
1185: CURSOR Fetch_Assessable_Val_Cur(cp_item qp_List_Lines_v.product_attribute_context%type) IS