[Home] [Help]
273: CURSOR C_ITEM_TARIFF IS
274: SELECT
275: B.ITEM_TARIFF
276: FROM
277: JAI_INV_ITM_SETUPS B
278: WHERE B.INVENTORY_ITEM_ID = CF_CETFORMULA.INVENTORY_ITEM_ID
279: AND B.ORGANIZATION_ID = P_ORGANIZATION_ID;
280: LV_ITEM_TARIFF JAI_INV_ITM_SETUPS.ITEM_TARIFF%TYPE;
281: BEGIN
276: FROM
277: JAI_INV_ITM_SETUPS B
278: WHERE B.INVENTORY_ITEM_ID = CF_CETFORMULA.INVENTORY_ITEM_ID
279: AND B.ORGANIZATION_ID = P_ORGANIZATION_ID;
280: LV_ITEM_TARIFF JAI_INV_ITM_SETUPS.ITEM_TARIFF%TYPE;
281: BEGIN
282: OPEN C_ITEM_TARIFF;
283: FETCH C_ITEM_TARIFF
284: INTO LV_ITEM_TARIFF;