APPS.JAI_PO_OSP_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 216: FROM JAI_CMN_INVENTORY_ORGS

212: FROM dual;
213: --*****************OSP RETURN DAYS****************************
214: CURSOR c_osp_days(cp_org_id NUMBER) IS
215: SELECT osp_return_days, osp_excise_percent
216: FROM JAI_CMN_INVENTORY_ORGS
217: WHERE organization_id = cp_org_id;
218: --******************CHECK IF 57F4 HEADER EXISTS***************** VNK
219: CURSOR c_header_exists(cp_org_id NUMBER, cp_loc_id NUMBER) IS
220: SELECT count(*)

Line 906: FROM JAI_CMN_INVENTORY_ORGS

902: WHERE wip_entity_id = cp_wip_entity;
903:
904: CURSOR c_osp_days IS
905: SELECT osp_return_days, osp_excise_percent
906: FROM JAI_CMN_INVENTORY_ORGS
907: WHERE organization_id = r_base_trx.organization_id;
908:
909: CURSOR c_item_value(cp_item_id NUMBER, cp_uom_code VARCHAR2) IS
910: SELECT pll.list_price