APPS.OKL_BLK_AST_UPD_PVT dependencies on CSI_ITEM_INSTANCES

Line 217: FROM csi_item_instances

213: --RKUTTIYA added for bug: 3569441
214: CURSOR c_loc_typecode(p_instance_id IN NUMBER) IS
215: SELECT LOCATION_TYPE_CODE,
216: INSTALL_LOCATION_TYPE_CODE
217: FROM csi_item_instances
218: WHERE INSTANCE_ID = p_instance_id;
219:
220: --Added by rkuttiya for Sales Tax project
221: CURSOR c_bill_upfront_tax(p_contract_id IN NUMBER,

Line 1793: FROM csi_item_instances

1789:
1790: CURSOR c_loc_typecode(p_instance_id IN NUMBER) IS
1791: SELECT LOCATION_TYPE_CODE,
1792: INSTALL_LOCATION_TYPE_CODE
1793: FROM csi_item_instances
1794: WHERE INSTANCE_ID = p_instance_id;
1795:
1796: CURSOR c_get_entered_alc_trx(cp_kle_id IN NUMBER) IS
1797: SELECT TRX.ID,TRX.TSU_CODE, TXL.object_id1_new, TXL.object_id2_new,

Line 1906: FROM csi_item_instances

1902: -- updating installed base item.
1903:
1904: SELECT object_version_number
1905: INTO l_obj_no
1906: FROM csi_item_instances
1907: WHERE instance_id = l_c_ib_inst.id1;
1908:
1909:
1910: OPEN c_loc_typecode(l_c_ib_inst.id1);