APPS.JAI_PO_OSP_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 158: FROM JAI_CMN_INVENTORY_ORGS

154: FROM dual;
155: --*****************OSP RETURN DAYS****************************
156: CURSOR c_osp_days(cp_org_id NUMBER) IS
157: SELECT osp_return_days, osp_excise_percent
158: FROM JAI_CMN_INVENTORY_ORGS
159: WHERE organization_id = cp_org_id;
160: --******************CHECK IF 57F4 HEADER EXISTS***************** VNK
161: CURSOR c_header_exists(cp_org_id NUMBER, cp_loc_id NUMBER) IS
162: SELECT count(*)

Line 785: FROM JAI_CMN_INVENTORY_ORGS

781: WHERE wip_entity_id = cp_wip_entity;
782:
783: CURSOR c_osp_days IS
784: SELECT osp_return_days, osp_excise_percent
785: FROM JAI_CMN_INVENTORY_ORGS
786: WHERE organization_id = r_base_trx.organization_id;
787:
788: CURSOR c_item_value(cp_item_id NUMBER, cp_uom_code VARCHAR2) IS
789: SELECT pll.list_price