APPS.CSI_ASSET_VLD_PVT dependencies on CSI_I_ASSETS_H_S

Line 281: SELECT CSI_I_ASSETS_H_S.nextval

277:
278: l_inst_asset_hist_id NUMBER;
279:
280: BEGIN
281: SELECT CSI_I_ASSETS_H_S.nextval
282: INTO l_inst_asset_hist_id
283: FROM sys.dual;
284: RETURN l_inst_asset_hist_id;
285: END gen_inst_asset_hist_id;

Line 478: FROM csi_i_assets_h s,

474: ELSE
475: IF p_end_date < SYSDATE THEN
476: SELECT MAX(t.transaction_date)
477: INTO l_transaction_date
478: FROM csi_i_assets_h s,
479: csi_transactions t
480: WHERE s.instance_asset_id=p_inst_asset_id
481: AND s.transaction_id=t.transaction_id
482: AND t.transaction_id <> nvl(p_txn_id, -999999);