DBA Data[Home] [Help]

APPS.JA_JAINPLA_XMLP_PKG dependencies on JAI_INV_ITM_SETUPS

Line 277: JAI_INV_ITM_SETUPS B

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

Line 280: LV_ITEM_TARIFF JAI_INV_ITM_SETUPS.ITEM_TARIFF%TYPE;

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;