APPS.OKL_BLK_AST_UPD_PVT dependencies on CSI_ITEM_INSTANCES

Line 185: FROM csi_item_instances

181: --RKUTTIYA added for bug: 3569441
182: CURSOR c_loc_typecode(p_instance_id IN NUMBER) IS
183: SELECT LOCATION_TYPE_CODE,
184: INSTALL_LOCATION_TYPE_CODE
185: FROM csi_item_instances
186: WHERE INSTANCE_ID = p_instance_id;
187:
188: --Added by rkuttiya for Sales Tax project
189: CURSOR c_bill_upfront_tax(p_contract_id IN NUMBER,

Line 1761: FROM csi_item_instances

1757:
1758: CURSOR c_loc_typecode(p_instance_id IN NUMBER) IS
1759: SELECT LOCATION_TYPE_CODE,
1760: INSTALL_LOCATION_TYPE_CODE
1761: FROM csi_item_instances
1762: WHERE INSTANCE_ID = p_instance_id;
1763:
1764: CURSOR c_get_entered_alc_trx(cp_kle_id IN NUMBER) IS
1765: SELECT TRX.ID,TRX.TSU_CODE, TXL.object_id1_new, TXL.object_id2_new,

Line 1874: FROM csi_item_instances

1870: -- updating installed base item.
1871:
1872: SELECT object_version_number
1873: INTO l_obj_no
1874: FROM csi_item_instances
1875: WHERE instance_id = l_c_ib_inst.id1;
1876:
1877:
1878: OPEN c_loc_typecode(l_c_ib_inst.id1);