APPS.CSI_ML_UPDATE_PVT dependencies on CSI_I_ASSETS

Line 78: FROM csi_i_asset_interface csiai, csi_i_assets csia

74: --bnarayan added for R12
75: CURSOR asset_attrib_intf_cur (p_id IN NUMBER, p_instance_id IN NUMBER)
76: IS
77: SELECT csiai.*,csia.instance_asset_id csia_instance_asset_id, nvl(csia.object_version_number,1) asset_object_ver_num
78: FROM csi_i_asset_interface csiai, csi_i_assets csia
79: WHERE csiai.inst_interface_id = p_id
80: AND csia.instance_id(+) = p_instance_id
81: AND csia.fa_asset_id(+) = csiai.fa_asset_id
82: AND csia.fa_location_id(+) = csiai.fa_location_id ;